OCP Question (Perf Tuning)

From: Jay Wade <fish_dba_at_hotmail.com>
Date: Tue, 06 Jan 2004 10:44:26 -0800
Message-ID: <F001.005DBDD9.20040106104426@fatcity.com>

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?

1. The sort-merge join.
2. The nested loops join.
3. This depends on some sort parameter values.
4. 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: fish_dba_at_hotmail.com

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: ListGuru_at_fatcity.com (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). Received on Tue Jan 06 2004 - 12:44:26 CST