Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizer not using index on raw datatype column
On Feb 14, 8:16 pm, harvinde..._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
Please note that EXPLAIN PLAN will treat all bind variables as
VARCHAR2.
The execution path may be wrong.
The only execution path that counts is the execution plan in v
$sql_plan.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Feb 15 2007 - 06:11:03 CST