Tuesday, January 6, 2004, 1:59:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG> Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other MG> methos despite the price.
Does Oracle themselves *document* that what you say is the case? I believe you, but I'm not sure that Oracle documents what you just said, so short of looking at the code, I'm not sure how anyone could be expected to really *know* what the answer to the original question was, which makes me wonder if the question is really even a fair question to ask. Do we *know* that B is the case, or have we just always *observed* that it *happens to be* the case? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. MG> On 2004.01.06 13:44, Jay Wade wrote: >> Hello: >> >> I was looking through some OCP questions posted on the web and came across >> the one below. >> I believe the answer is (D), because the join type would be dependent on the >> number of rows within the table. Is this correct or does the OPTIMIZER_MODE >> set to FIRST_ROWS alter this behavior? >> >> >> The cost-based optimizer can choose between a nested loops join and a sort >> merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set >> to FIRST_ROWS. Which execution plan will be the result? >> >> a. The sort-merge join. >> >> b. The nested loops join. >> >> c. This depends on some sort parameter values. >> >> d. This depends on the number of rows in each table. >> >> _________________________________________________________________ >> Check your PC for viruses with the FREE McAfee online computer scan. >> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Jay Wade >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services -- 858-538-5051 http://www.fatcity.com >> San Diego, California -- Mailing list and web hosting services >> --------------------------------------------------------------------- >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). >> MG> -- MG> Mladen Gogala MG> Oracle DBA MG> -- MG> Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
