On 14 feb, 20:32, Maxim Demenko <mdeme..._at_arcor.de> wrote:
> harvinde..._at_gmail.com schrieb:
>
> > 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
>
> The index should be used if you tell optimizer explicitly, that your
> literal has raw datatype ( i.e.
> Select * from tab1 where raw_column = hextoraw('value');
> )
>
> Best regards
>
> Maxim
Implicit datatype conversion - always challenging...
Received on Thu Feb 15 2007 - 05:30:49 CST
