Re: Optimizer not using index on raw datatype column

harvinder76_at_gmail.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

Run an explain plan or autotrace with and without the hint. My guess is that the cost is higher with the index.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org