Posted by p_bali on 05/08/06 23:32

Hi,

I have an UPDATE statement which runs very slow (about 1-2 minutes) in
Web as well as in Query Analyzer. Very plain UPDATE statement; uses
indexes, etc. I though the reason might be the table being unorganized
because of the row expansions due to updating an existing column value
with a larger value. Therefore, I ran a maintanenance plan which
reorganizes data and rebuilds indexes. But, it seems that there is no
improvement.

Any thought or advise will be greatly appreciated.

Sincerely,

Pelin Bali.

[Back to original message]