Hints

From: <sweidanz_at_yahoo.com>
Date: Thu, 27 Sep 2001 18:07:37 +1000
Message-ID: <Q8Ps7.32$uX3.677@nsw.nnrp.telstra.net>

Folks,
Is it possible that Oracle optimiser would ignore the hint and does something different?
Here is my case:

First run: (no hints)
- execution plan says that the optimiser used the cost_based method.

Second run: hint /*+ RULE */
- The execution plan used an index in table A

Third run: hint /*+ Index tableA(indexname) */
- The optimiser did a FULL table scan on tableA.

Just wondering if thats possible, that the optimiser would ignore the hint, or i might be missing something here?

thanks,
ZS Received on Thu Sep 27 2001 - 03:07:37 CDT