Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Fri Aug 18 2006 - 13:22:13 CDT
![]() |
![]() |