RE: Optimizer not using index on raw column

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 14 Feb 2007 15:18:06 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A98173AF@usahm208.amer.corp.eds.com>

Did the index exist the last time the table statistics were collected? Were statistics generated on the index?  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh

	Sent: Wednesday, February 14, 2007 2:12 PM
	To: oracle-l
	Subject: Optimizer not using index on raw column
	
	

	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          

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 14 2007 - 14:18:06 CST