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

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? Received on Fri Nov 03 2006 - 08:31:04 CST