Re: Low hit ratio, but only for indexes

Keith Boulton doodled thusly:

>
>Nuno Souto <nsouto_at_optushome.com.au.nospam> wrote in message
>news:3c443955.1313124_at_news-vip.optusnet.com.au...
>> > I ran an explain plan on one
>> >of their slow queries and it does 2 full table scans of a 7M row
>> >table.
>>
>> Yikes! Still, that shouldn't take too darn long, unless the tables
>> have very large rows.
>
>Unless the two full scans are nested!
>
>

he says it's two full table scans. it can't be nested nor hashed.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Jan 17 2002 - 02:59:59 CST