|
[oracle-l]
||
[Date Prev]
[05-2006 Date Index]
[Date Next]
||
[Thread Prev]
[05-2006 Thread Index]
[Thread Next]
Re : *Measuring sql performance (elapsed time and scalability) by number of logical reads
- From: Bernard Polarski <bpolarsk@xxxxxxxxx>
- To: cichomitiko@xxxxxxxxx
- Date: Tue, 2 May 2006 06:15:42 -0700 (PDT)
Hash join are usually better when the cardinality to process is high. With
small cardinality nested loop tend to be more efficient. The cardinality here
for both SQL are not that big.
check what oracle says about it :
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_1016.htm#sthref1085
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/optimops.htm#sthref1397
B.Polarski
http://www.smenu.org
|
