Not specific to anyone, but for this thread, there was a couple of good articles by Tom Kyte in a recent Oracle Magazine: http://www.oracle.com/technology/oramag/oracle/06-may/o36asktom.html Of course, every shop is different... Rich Disclaimer: I've both hated and loved the CBO (on the same day)... ;) -- //www.freelists.org/webpage/oracle-l