Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Low hit ratio, but only for indexes
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! Received on Tue Jan 15 2002 - 14:57:11 CST