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: query performance -- revised!

Re: query performance -- revised!

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 29 May 2003 07:19:45 +0200
Message-ID: <j06bdvsprsun9o8c6o03907dti86p258el@4ax.com>


On Wed, 28 May 2003 17:28:18 -0700, "Mikito Harakiri" <mikharakiri_at_ywho.com> wrote:

>Also consider the following:
>5. Change the order of the tables in the from clause. Try all the
>permutations.
>6. Add "and exist(select 1 from dual)". Mix it with " and exist(select 2
>from dual)" sparingly.
>7. Try capital letters in the table names -- optimiser respect those more.
>8. Start playing with init.ora parameters. There are too many of those to
>check all the permutations, but give it a shot.

He is running CBO, isn't he? So what will the suggestions above do? Apart from introducing stupid MYTHS, exactly NOTHING!!!!!

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu May 29 2003 - 00:19:45 CDT

Original text of this message

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