The points about the indexes are very interesting. I have about 7 indexes
on the table. I limited the indexes to columns i really needed them on.
None of the indices are unique though. I have a single constraint for the
table that does not involve the column being updated. How do I go about
deactivating an index before running the SP. After that how do I go about
activating again afterwards. My big question of course, is that when I
activate after a couple million updates how long will it take to rebuild the
index and how will that affect select statements being run on it?