or hashed.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Keith Boulton" <kboulton_at_ntlworld.com> wrote in message
news:ME018.28979$_x4.4014030_at_news2-win.server.ntlworld.com...
>
> 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 Wed Jan 16 2002 - 04:10:37 CST
