Does NOT automatically cause a full table scan? 9.2.0.5

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 - 07:37:42 CST