Hints Redundant With Oracle 9i And The CBO?
"Tom Kyte swears that if you properly analyze your table, the CBO is at the point where you never need hints. I find I still need them 'occasionally', though not very often. Anyone else have opinions? anyone who beta tested 10g see an improvement in the CBO? IT tends to get a little better with each release." asks Ryan Gaffuri on comp.databases.oracle.server. Here's the link to Tom's previous answer on this topic.