Oracle estimate table join cardinality - Oracle Consulting, Oracle Support and Oracle Training by BC

In the absence of column histograms, Oracle CBO must be able to “guess” the result set size and he sometimes gets it wrong. This is one reason why the ORDERED hint is one of the most popular SQL tuning hints, because using the ORDERED hint allows you to .

www.dba-oracle.com