Re: how to tune up this query?

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Fri, 31 Jan 2003 10:57:44 -0000
Message-ID: <IEs_9.6620$V6.8523@news.indigo.ie>

Naaa. read the rest of the thread ....
"Thomas Niering" <thomas.niering_at_arcor.de> wrote in message news:8euF5o6YXzB.thomas.niering_at_arcor.de...
>
> 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 Fri Jan 31 2003 - 04:57:44 CST