Re: how to tune up this query?

Telemachus (telemachus_at_ulysseswillreturn.net) wrote:
: What's the response time from

: SELECT /* +FULL(table_name) */ id, name, priority FROM
: (SELECT id, name, priority FROM table_name
: WHERE stage = 'start' and state = 1 ORDER BY priority ASC)
: WHERE rownum <= 1000;
: >

: HOW LONG does the first query take ?

There is also an optimize hint for selecting whether you wish the query to return the first rows as soon as possible, or the complete data set as quickly as possible.

I'm not sure off hand what the default is, but you want to make sure you are returning the first rows as soon as possible since since those are the only rows you want. Received on Thu Jan 30 2003 - 21:32:49 CST