Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select with lots of JOINS

Re: Select with lots of JOINS

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Thu, 18 May 2006 07:18:36 -0700
Message-ID: <tn%ag.6789$KB.451@fed1read08>


"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message news:e4fmst$1t2$1_at_news6.zwoll1.ov.home.nl...
> bdbafh_at_gmail.com schreef:
>
> > R2 OEM tuning advisor (separately licensed option) and what color is
> > the database server".
>
> and... did you try the -- go_faster hint in 11.0.1 (aka 11k)?
> <g>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

The "go_faster" hint in 11.01 (aka 11k) is cool, but in my opinion, the "_ludicrous_speed" parameter is much more effective, but be careful, if overused the database might go plaid.

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.
Received on Thu May 18 2006 - 09:18:36 CDT

Original text of this message

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