|
|
Posted by Erland Sommarskog on 05/09/06 00:34
(p_bali@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, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|