Hi,

I have 2 options when inserting huge amount of data into tables inside a stored procedure. Can someone please suggest which is a better option to improve performance?

1. Drop all the index, insert into tables and recreate the index - all done inside the sp.

2.Drop all the index, insert into the table;                                                                                                                                                  Outside the sp, run a separate batch to recreate index on all tables.

Thanks.

 What recovery model is your database using?