Re: OCP Question (Perf Tuning)

D is probably the answer, but most of the time oracle will choose nested loop.

Beware the OCP tuning test. It is completely and totally inaccurate. I emailed the author of the Sybex tuning book and he agreed with me. He said he wrote the book to the test and knows its garbage.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 06, 2004 1:44 PM

> 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: 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: Ryan
  INET: ryan_oracle_at_cox.net

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