If You have a table T and there is a field x which is nullable then an index on that column (b*tree) index would not be used by oracle in a query like below
select * from t where x = :bv1.
but there is a workaround for this
you can create an index like this
create index t_b1 on t(0,x) ;
then oracle will use that index.
Wednesday, August 8, 2007
Subscribe to:
Post Comments (Atom)
1 comment:
Tips from a genuine expert. And its wonderful to come across your blog. Maybe you'd care enough to launch a tutorial page for beginners!
Post a Comment