Re: query performance -- revised!

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 29 May 2003 21:37:40 +1000
Message-ID: <40mBa.45638$1s1.611985@newsfeeds.bigpond.com>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3ed5c393$0$19598$ed9e5944_at_reading.news.pipex.net...
> "Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
> news:dBcBa.19$we7.173_at_news.oracle.com...
>
> > 7. Try capital letters in the table names -- optimiser respect those
more.
>
> Ah, so you are joking right - missed that before
>
>

Hi Niall,

You may find this hard to believe but I find if I title my tables appropriate (eg. SELECT * FROM Mr_Emp, or SELECT count(*) FROM Mrs_Dept), I find that the optimizer pays a *huge* amount of respect to such queries, ignores everything else and dedicates itself to ensuring it delivers the *perfect* execution plan.

Honestly, give it a go, you'll be just amazed at the results ....

Cheers ;)

Richard Received on Thu May 29 2003 - 06:37:40 CDT