Use of Indexing in Table with DML operations

Other SQL Server Topics
1

I have table with up to 1 million records.
There is an .exe which deletes all the records from the table and again inserts all the records.
Should I used indexing on this table or not?

Thanks in advance...:slightly_smiling_face:

2

Depends on what it is being used for.
This sounds like a staging table. Should the resulting data be merged with repository data for users to access? Then you shouldn't need to index this volatile table and statistics might bot change as much on the repository version.

1 Like