Update statement performance problem

[p_bali]

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.

[Erland Sommarskog]

(p_****@hotmail.com) writes:

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.

Please include:

o The actual UPDATE statement.
o CREATE TABLE and CREATE INDEX statements for the involved tables.
o Indication of query sizes.
o The output when running the query with SET STATISTICS PROFILE ON.

From the information you have given, only wild guesses are possible.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx