And the most interesting thing that Query Analizer displays different Estimated Execution Plan... :(
How it can be?
>I have two databases with have indentical structure of tables and indexes.
>And now I have a problem with one query, which is working perfectly on one of DB but it is lagging on another. And this lagging is very interesting, because query is running as usual but after processing more then half results Query Analiser wait for more than 1 minute and then process last records.
>Can it be something wrong with indexes?
>It there any reindexing on SQL Server 7?
>How to check where is the bottleneck?
Giedrius