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

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 Received on Fri Aug 18 2006 - 13:30:51 CDT