Optimizer not using index on raw column

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
 

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 14 2007 - 13:11:47 CST