Re: how to tune up this query?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 30 Jan 2003 08:58:22 -0000
Message-ID: <3e38e92e$0$230$ed9e5944@reading.news.pipex.net>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:v3hdqlh378ru79_at_corp.supernews.com...
> Why are we ordering by stage when stage = 'start'?. Remove the order by
clause, put proper indexes ...
> and you should be happier.

I also thought this, but suspect that it is a typo and should read ORDER BY priority ASC, since the text description refers to retrieving the 1000 lowest priority records.

I agree about seeing an explain plan though.

--
Niall Litchfield
Oracle DBA
Audit Commission UK.

Received on Thu Jan 30 2003 - 02:58:22 CST