Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Optimizer not using index on raw datatype column

Optimizer not using index on raw datatype column

From: <harvinder76_at_gmail.com>
Date: 14 Feb 2007 11:16:32 -0800
Message-ID: <1171480591.517944.234960@s48g2000cws.googlegroups.com>


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 Received on Wed Feb 14 2007 - 13:16:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US