Laimutis Nedzinskas wrote:
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jonathan Lewis " The first STRATEGIC step is to get the system statistics set so that the optimizer has a truthful image about the time cost of multiblock reads, and the CPU cost of doing tablescans. "
Can you elaborate a bit more what can be considered for this truthful
image apart from the straightforward "compute all for all cascade all"? The only thing left seems to be the histograms which, yes, opens a lot
Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-l