By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

Update statement performance problem

P: n/a
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.

May 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(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
May 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.