Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to avoid an index that is part of a view

How to avoid an index that is part of a view

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Fri, 18 Aug 2006 14:22:13 -0400
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C0038A7557@usa0300ms03.na.xerox.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US