Viewing 2 posts - 16 through 17 (of 17 total)
Using a clustered index on a table that has a lot of inserts/updates/deletes is not always a good idea. Clustered indexes keep the data ordered in PHYSICAL order. So the...
July 23, 2004 at 8:48 am
#515915
You mentioned that this table has 26+ million records in it, and that is receives a
lot of activity. If you are getting a lot of inserts and updates, make sure...
September 29, 2003 at 10:20 am
#476242