Can you post an explain plan for this? you may find that oracle rewrote
your query. It could have also ran your query based on an index of t.b
and taken the result set and filtered out the x,y,z.
Also, histograms will only be used if you created them. I have no idea
if you did since you didn't post anything about that.
Ben 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';
Received on Fri Nov 03 2006 - 11:51:35 CST
