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

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: Amir.Hameed@xxxxxxxxx
  • Date: Fri, 18 Aug 2006 15:30:07 -0400

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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxx [mailto:Jay.Miller@xxxxxxxxxxxxxxxx]
Sent: Friday, August 18, 2006 2:28 PM
To: Hameed, Amir; oracle-l@xxxxxxxxxxxxx; breitliw@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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


--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l





--
----------------------------------------------
Got RAC?

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006