Re: Optimizer not using index on raw column
- From: "John Darrah" <darrah.john@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx
- Date: Wed, 14 Feb 2007 12:26:39 -0700
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@xxxxxxxxxxxxx> 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
Other related posts: