Re: same query is now 30 times slower
From: Ashish Mittal <mittalashish_at_yahoo.com>
Date: Sat, 23 Mar 2002 15:49:55 GMT
Message-ID: <Du1n8.110410$uA5.89747_at_rwcrnsc51.ops.asp.att.net>
Date: Sat, 23 Mar 2002 15:49:55 GMT
Message-ID: <Du1n8.110410$uA5.89747_at_rwcrnsc51.ops.asp.att.net>
Can you please post the select?
"Jason Separovic" <sepo_at_bigpond.net.au> wrote in message
news:gvWm8.1978$EE4.6988_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 - 16:49:55 CET