Question

Stored Procedure for dropping indexes

Indexes, DROP, Restore, Stored procedures

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?

What database platform are you using?

While this can be done, it is more efficient and much safer to hard code the list of indexes which need to be dropped into a stored procedure, and the same with the create index commands. It requires a little more maintenance when ever indexes are added to the tables, but the end result will be much better.