Re: same query is now 30 times slower
From: Zakir <zsyed5_at_shaw.ca>
Date: Sun, 24 Mar 2002 19:19:37 GMT
Message-ID: <dFpn8.200843$kb.11151417_at_news1.calgary.shaw.ca>
Date: Sun, 24 Mar 2002 19:19:37 GMT
Message-ID: <dFpn8.200843$kb.11151417_at_news1.calgary.shaw.ca>
Analyze your tables(analyze command in sql for optimization) related to that query. Hope this solves.
Zakir
"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 Sun Mar 24 2002 - 20:19:37 CET