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 -> Re: Optimizer not using index on raw datatype column

Re: Optimizer not using index on raw datatype column

From: <frank.van.bortel_at_gmail.com>
Date: 15 Feb 2007 03:30:49 -0800
Message-ID: <1171539049.588659.96120@q2g2000cwa.googlegroups.com>


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

Original text of this message

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