Optimizer not using index on raw column
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 14 Feb 2007 14:11:47 -0500
Hi,
We have an unique index on raw(16) column but whenever we issue a query
on this table optimizer is doing fullscan and not using the index but
when I force index it works fine:
Select * from tab1 where raw_column = 'value';
Is this expected behavior that when we refer RAW columns in query that
Optimizer not use the index?
Thanks
--Harvinder
Other related posts:
