I would like a stored procedure that will take as input the name of a table.
Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops.
Then I would like another strored procedure that takes a table name as input and puts back all the indexes that were dropped.
We need to load 1 to 3 million rows a night and we manually drop all the indexes and put them back after the load. Is this something that can be written as a stored procedure?
February 28, 2008 4:04 PM
March 3, 2008 12:46 PM