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

Amir,
Since you mention that this is a non-selective Index, have you considered using Histograms? Since this is an Apps Database, additional histograms (other than the seeded ones) need to be created via manual additions to APPLSYS.FND_HISTOGRAM_COLS table. Look at my ML Note 358323.1
titled "Judicious Use of Histograms for Oracle Applications Tuning". You can derive the benefits of not touching the code, but yet influence the CBO :)

John Kanagaraj

On 8/18/06, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> 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