RE: OCP Question (Perf Tuning)

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Tue, 06 Jan 2004 11:54:48 -0800
Message-ID: <F001.005DBDEA.20040106115448@fatcity.com>

FIRST_ROWS would alter the behavior regardless of the number of rows.

-----Original Message-----
Jay Wade
Sent: Tuesday, January 06, 2004 1:44 PM
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <Paula_Stankus_at_doh.state.fl.us
  INET: Paula_Stankus_at_doh.state.fl.us

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 - 13:54:48 CST