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