Sample Header Ad - 728x90

REINDEX or REBUILD the indexes of a table after truncating it and then repopulating it?

0 votes
1 answer
8238 views
Is it necessary to REINDEX or REBUILD the indexes of a table after truncating it and then repopulating it? I have a table with approximately 3.5 million rows in Oracle. Every week new data is recharged, truncating the table and then loading the data. There are 2 or 3 indexes in the table. Should I delete and re-create the indexes or simply rebuild the ones I already have? , some indexed columns are encrypted with TDE. Thank you
Asked by Arnaldo Raxach (145 rep)
Nov 20, 2018, 04:27 AM
Last activity: Nov 20, 2018, 10:02 AM