Re: same query is now 30 times slower

Hi

Maybe is something related to the SQL optimizer.

Even being the same query etc, for some reason the
optmizer rules may be changed, or someone could have
dropped the tables statistics, or something like that...

Or maybe something more simple, as one index that have been dropped or modified.

lc

"Jason Separovic" <sepo_at_bigpond.net.au> wrote in message news:<0wWm8.1981$EE4.6978_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.
Received on Sat Mar 23 2002 - 15:07:21 CET