Re: Suggestions on how to efficiently search a large table

On Thu, 15 Nov 2007 09:14:25 -0800 (PST), EdStevens <quetico_man_at_yahoo.com> wrote:

>On Nov 15, 8:35 am, chrism..._at_gmail.com wrote:
>> On Nov 15, 7:42 am, bdbafh <bdb..._at_gmail.com> wrote:
>
>If removing the rownum filter would produce a 10,000,000 row result
>set, it still has to get those 10,000,000 rows before rownum can be
>assigned and determined. So I don't think limiting on rownum is going
>to have any appreciable impact on access plan or query performance.

I recall Tom Kyte had an article on 'guessing' the top #.

-a
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Nov 15 2007 - 11:21:57 CST