optimization
Hi everybody!
I need to get the last entry of a table, so I'm using the following query:
SELECT * FROM table WHERE (some conditions) ORDER BY date DESC LIMIT 0,1
This seems a little bit stupid... Does anybody know an another way to do that? Can I keep a ordered table and than avoi the use of "order by"? If yes, how can I do that?
Thaks in advance and sorry about my poor English!
eo
Subject
Written By
Posted
optimization
August 03, 2005 03:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.