Re: Does NOT automatically cause a full table scan? 9.2.0.5

frank.van.bortel_at_gmail.com wrote:
> On Nov 3, 2:37 pm, "Ben" <bal..._at_comcast.net> wrote:
> > 9.2.0.5 Ent Ed AIX5L
> >
> > Does NOT automatically cause a full table scan or is that dependant
> > upon histograms and the skew of the data? For example a statement like
> >
> > select t.a, t.b, t.c
> > from t
> > where t.b = 'abc'
> > and not t.a = 'xyz';
>
> Depends on the existance of indexes in the first place.
> Not quite sure what you are actually asking. Did you
> expect a FTS and you did not get one?

yes, sorry, for example sake we'll say that t.a is indexed. I was just told that if a statement has NOT in it, then regardless of all else, you would get a full table scan. I don't think anything in Oracle is that cut and dry though. Received on Fri Nov 03 2006 - 09:18:53 CST