I have a table that gets rebuilt every day after truncate. Have created a composite index idx1 on col1 and col2...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
(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.