I run a SQL script on a server with 8 CPUs. The script took exceptionally long when updating two ntext fields in a table that has more than 3,000,000 records.
Before adding a nonclustered index:
The server showed 100% cpu committed and updated about 20,000 rows/hr
After adding a nonclusterd index:
The server updated 15,000 rows/min(not hr!).
I was shocked by such a big improvement.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment