RE: CBO - hash join vs nested loops
- From: "Laimutis Nedzinskas" <lnd@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Dec 2005 15:53:40 -0000
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
possibilities.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
