I have a table that gets rebuilt every day after truncate. Have created a composite index idx1 on col1 and col2...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
(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.