RE: How to avoid an index that is part of a view

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Fri, 18 Aug 2006 15:44:25 -0400
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C0038A7559@usa0300ms03.na.xerox.net>

That worked Raj! Thanks

---

	From: rjamya [mailto:rjamya_at_gmail.com] 
	Sent: Friday, August 18, 2006 3:30 PM
	To: Hameed, Amir
	Cc: Jay.Miller_at_tdameritrade.com; oracle-l_at_freelists.org
	Subject: Re: How to avoid an index that is part of a view
	
	
	that was due to syntax error ... 
	
	you need 
	
	/*+ no_index(view_alias.table_alias_inside_view_definition,

index_name_you_wish_to_avoid) */         

        Raj                  

        On 8/18/06, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> wrote:

                I have tried the full hint, no_index hint but I believe that because the

                table is not directly part of the query and is part of the view being

                referenced in the query, therefore, the hints have had no impact                 

-----Original Message-----

                From: Jay.Miller_at_tdameritrade.com
[mailto:Jay.Miller_at_tdameritrade.com]

		Sent: Friday, August 18, 2006 2:28 PM 
		To: Hameed, Amir; oracle-l_at_freelists.org;
breitliw_at_centrexcc.com
		Subject: RE: How to avoid an index that is part of a

view                 

                Have you tried using a /*+ FULL(table_name) */ hint?                                                   

		Thanks,
		Jay Miller
		Sr. Oracle DBA
		x68355
		
		


		-----Original Message-----

		From: oracle-l-bounce_at_freelists.org 
		[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Hameed, Amir
		Sent: Friday, August 18, 2006 2:22 PM
		To: oracle-l; Wolfgang Breitling
		Subject: How to avoid an index that is part of a view 
		
		I have a query that is referencing a column in its where
clause which is
		part of a view. The column in the view has an index
which is not very
		selective. This index's table is a standard Oracle Apps
table and 
		therefore we can not tinker with its indices. I would
like to avoid the
		optimizer from using the index which part of the view.

How do I do it:                 

		Thanks
		^Amir
		
		


		--

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


		--

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




	-- 
	----------------------------------------------
	Got RAC?
	

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

Received on Fri Aug 18 2006 - 14:44:25 CDT