Re: query performance -- revised!

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 29 May 2003 09:23:47 +0100
Message-ID: <3ed5c393$0$19598$ed9e5944@reading.news.pipex.net>

"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:dBcBa.19$we7.173_at_news.oracle.com...
> Also consider the following:
> 5. Change the order of the tables in the from clause. Try all the
> permutations.

This will most likely make no difference at all

> 6. Add "and exist(select 1 from dual)". Mix it with " and exist(select 2
> from dual)" sparingly.

huh?

> 7. Try capital letters in the table names -- optimiser respect those more.

Ah, so you are joking right - missed that before

> 8. Start playing with init.ora parameters. There are too many of those to
> check all the permutations, but give it a shot.

yep definitely joking.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Thu May 29 2003 - 03:23:47 CDT