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 : *Measuring sql performance (elapsed time and scalability) by number of logical reads

Re : *Measuring sql performance (elapsed time and scalability) by number of logical reads

From: Bernard Polarski <bpolarsk_at_yahoo.com>
Date: Tue, 2 May 2006 06:15:42 -0700 (PDT)
Message-ID: <20060502131542.4516.qmail@web36510.mail.mud.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 02 2006 - 08:15:42 CDT

This message: [ Message body ]
Next message: Radoulov, Dimitre: "Re: easuring sql performance (elapsed time and scalability) by number of logical reads"
Previous message: Mercadante, Thomas F \(LABOR\): "RE: Is an Oracle license required for a development environment?"
In reply to: Morten Egan: "Re: *Measuring sql performance (elapsed time and scalability) by number of logical reads"
Next in thread: Cary Millsap: "RE: *Measuring sql performance (elapsed time and scalability) by number of logical reads"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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