Re: Select with lots of JOINS

From: Robert Klemme <bob.news_at_gmx.net>
Date: Thu, 18 May 2006 16:39:01 +0200
Message-ID: <4d3f85F16fm5mU1@individual.net>

Andreas Sheriff wrote:

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

IIRC it was called "ridiculous_speed" and not "ludicrous_speed". But I agree, it has to be used with care (helmet damage can be caused by switching it off too fast).

        robert Received on Thu May 18 2006 - 09:39:01 CDT