Hints Redundant With Oracle 9i And The CBO?

October 9th, 2003 by Mark Rittman

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.

Comments are closed.