Posted by serge on 10/17/66 11:37

> Unfortunately, I have never heard of this before. It sonds very strange.

Today when I went to work I saw the developer of this file had
updated the code and I noticed the tablename that was causing
my problem was removed. The statement was part of a
EXISTS or NOT EXISTS statement and when I quickly looked
at what was removed and replaced with, I believe the table that
was causing the problem was in the original SELECT statement
before the EXISTS or NOT EXISTS condition.
Anyhow I have kept the database and the problem as a copy
and if I do find the time in the near future I will try to troubleshoot
it further.

>> It was a big plan that I had waited for around 35 minutes before I
>> got it. There were I think 2 statements of INSERT to a #temp table
>> taking about 32% each so that seemed to be the big overhead in the
>> execution plan.

> A tip is to use SET STATISTICS_PROFILE ON. This gives you output in
> text form, that you save to disk. Run this on both versions, and then
> use Beyond Compare (http://www.scootersoftware.com) to compare the
> output. Beyond Compare is good for this, becausee it produces diffs
> on character level.

Very good idea I'll keep this mind to compare execution plans instead
of going through long graphical execution plans.

Thanks again.

[Back to original message]