I have a table that gets rebuilt every day after truncate. Have created a composite index idx1 on col1 and col2 (not clustered) on that and also two more indexes to speed up the processing.
This table is a continuously growing, like 400 new index values for idx1. And now it has around 170,000 records. So since I truncate and repopulate the data, is the index of much use? On truncate will the space utilized for index get released?
This was first published in July 2007