Re: Optimizer not using index on raw column

Its probably doing an implicit conversion to varchar2. Try

Select * from tab1 where raw_column = hextoraw('value');

On 2/14/07, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:
>
> 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