Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NO_INDEX hint not being used

133645Oct 18 2011 — edited Oct 24 2011
I have a query whose rough outline is

select x,y,x
from
t,
u,
v => v is a view
(where clause)

The view is written like
SELECT /* NO_INDEX(RTE ANNOYINGINDEX */
x,y,z
FROM dwbx.largepartitionedtable RTE,
a,
b,
c

I've tried putting the no_index hint in the select.. I've tried putting in the view and the select.. I've also tried sticking with the alias, RTE, as well as the table name..
I really can't drop this index, but I have to prevent the query from using it. It keeps using this index. Any suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2011
Added on Oct 18 2011
8 comments
345 views