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?
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.