That hint tells the optimizer to ignore the index on the view altogether.
When you use an indexed view properly you do not have to specify the
indexed view itself but rather the underlying table. The optimizer will
decide if the view is more efficient and if so it will use that instead of
the base tables. There is no equivalent for UDF's.
My understanding of the "Expand View" option for an indexed view causes
the
optimizer to replace the view name with the view definition. I'd like to
do
the same thing for a User Defined Function. Possible?
Re: Oracle Hint Behavior ...Oracle would treat them as only "suggestions" but I thought in 10g they ... like to be able to explain why the hint is being ignored now. ... There is an interesting way to influence the optimizer without the use ... of DEC Rdb right after Oracle acquired Rdb back in '94/'95 timeframe. ... (comp.databases.oracle.server)
Re: Why Statistics doesnt match reponse time? ... > four patches since then that have substantially improved the optimizer....Patches would not help him here. ... His hint causes the optimizer to do the ... As for the Oracle 9.2.0.6, the latest version, the optimizer was improved, ... (comp.databases.oracle.server)
Precisely govern an entire explain plan ... plan & access paths you want? ... You can't specify a hint to ... How could I force the optimizer to first join TAB1 and TAB3 ... (comp.databases.oracle.server)
Re: select value within an interval ... Any idea why Oracle reads the whole table or does index FFS if I use ... If you are going to hint "fully" hint as recommended by Jonathan Lewis. ... Be sure that the information you are providing to the optimizer is what ... (comp.databases.oracle.server)
Re: Index not getting used ... the query under focus has a OR condition with both the ... > Putting a Ordered by hint is better then no hint but still is not as ... > good as Rule hint, why is it so, I want to avoid putting a Rule hint ... to put in several other hints to ensure that the optimizer... (comp.databases.oracle.server)
