Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query performance -- revised!
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