RE: Optimizer not using index on raw column

Did the index exist the last time the table statistics were collected?
Were statistics generated on the index?
 
-- Mark D Powell -- 
Phone (313) 592-5148 
 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh
        Sent: Wednesday, February 14, 2007 2:12 PM
        To: oracle-l
        Subject: 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

Other related posts: