| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: how to tune up this query?
Hallo Telemachus,
> She does need to do this sort of thing if she wants to use ROWNUM
> since otherwise she can't pull out the first 1000.
The original select searchs for 'start' in the field stage and sort the *same* field stage to get the first 1000. Why sorting?
Ciao Thomas Received on Thu Jan 30 2003 - 23:58:00 CST
 |
 |