Yes... and it's obsolete in V9 [as I was reminded in another recent thread]
"Malcolm Dew-Jones" <yf110_at_vtn1.victoria.tc.ca> wrote in message
news:3e39ee61_at_news.victoria.tc.ca...
> 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 Fri Jan 31 2003 - 04:56:50 CST
