|
|
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.
Navigation:
[Reply to this message]
|