NO_INDEX hint not being used
133645Oct 18 2011 — edited Oct 24 2011I 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?