[SOLVED] Optimizing Hint not 'taken'.
595110Dec 26 2007 — edited Jan 9 2008Hi
Even though I have read in the Oracle White Paper 'Query Optimization in Oracle9i' that hints should be avoided for optimization when possible, I still would like to know why is it that when I provide the hint /*+ INDEX_DESC(COLLECTION COLLECTION_RECPTDT) */ so that a query uses the index COLLECTION_RECPTDT for the execution of the query it doesn't when the documentation says if would.
Any suggestions on when hints or may not be used are welcome too.
Thank You.
Message was edited by:
One