Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cost of hash join

RE: Cost of hash join

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 13 Jun 2005 10:52:13 +0200
Message-ID: <7F0C000A3ABA6241A10C9ABF37EEB46D0F01D8@MSXVS01.trivadis.com>


Hi Christo  

>Where did you get the number of slots available and needed from?
>
>"In the second case we need about 116 slots but only 17 are available"

My apologies, there's an error here... What I meant is "166 times the available memory for the slots".

>Which trace told you that ? I cant seem to find tehse numbers
>(especially 116) in the trace outputs you gave.
 

My understanding/guess is that the CBO compares the "result set size" ("bytes" in execution plan) with "memory for slots".  

In the first case 400000 is smaller than 983040 --> therefore low cost.

In the second case 80400000 is much greater than 696320 (about 116 times) --> therefore "high" cost.    

HTH Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 13 2005 - 04:57:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US