Re: same query is now 30 times slower

From: Ed prochak <ed.prochak_at_alltel.com>
Date: 23 Mar 2002 08:48:06 -0800
Message-ID: <e51b160.0203230848.4ebd2228@posting.google.com>

"Jason Separovic" <sepo_at_bigpond.net.au> wrote in message news:<WvWm8.1979$EE4.6882_at_news-server.bigpond.net.au>...
> Has anyone ever experienced a problem where a nested select statement which
> first took a minute now takes half an hour. It is the exact same query on
> the exact same dataset on the exact same database.

Has the index been dropped?

Maybe the table statistics are stale. Has the table been ANALYZEd recently? (Does the EXPLAIN PLAN look the same?)

Are you now querying through a database link?

Something must have changed. Received on Sat Mar 23 2002 - 10:48:06 CST