hello,
im in a process of developing ssis package to bulk load data into few tables. some of the tables are very large. hence im planning to disable indexes before bulk insert operation and then enabling it again. My question is disbling vs dropping indexes (and enabling / creating after bulk insert) which operation will give me best insert performance? will they both same from performance standpoint?
second question is im not planning on dropping or disabling clustered indexes as i believe it will not give me performance improvement since clustered indexes are same as heap tables without index on it. Let me know if my understanding is correct.