Is it necessary to generate the statistics of a table after truncating it and then repopulate it? I have a table with several million rows in Oracle.Every week new data is recharged, truncating the table and then loading the data.
Each time a new data load is made, I must generate the statistics again. Should I also rebuild the indexes? Some columns are encrypted with TDE. Thank you