Learn to use your posting software Niall!
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3deb7b2a$0$711$ed9e5944_at_reading.news.pipex.net...
> I have two (very) similar queries which execute in radically different
> timescales.
<snip detail>
What I should have added was that (unless I can't read) the execution plans
are the same, which isn't a huge surprise because the queries are actually
designed to return the same set of data (there aren't any values in
AAGDAENQ3 for clients other than 'AC'). What is confusing me a bit is why
the second query should visit an order of magnitude more blocks (4million
not 300k).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Dec 03 2002 - 04:16:02 CST
