Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Does NOT automatically cause a full table scan? 9.2.0.5

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

From: Ben <balvey_at_comcast.net>
Date: 3 Nov 2006 07:18:53 -0800
Message-ID: <1162567133.536267.268050@f16g2000cwb.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US