0

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

Improve this question

1 Answer 1

Reset to default
-1

As a general guidelines, it is usually recommended to do a gather stats on table whenever more than 10% of the rows are modified. So in your case, you will need to do a stats gather post data load. The index stats gather are taken care of if we do table stats gather using cascade option.

Improve this answer
2
  • 1
    "If you have gathered table stats using cascade option, then index rebuilds are not required that frequently and can we done once a month or so." That sound weird. Why should he rebuild indexes every month? And nobody rebuilds an index to get a statistic for this index. There is a related question from this user
    – miracle173
    Commented Nov 20, 2018 at 13:13
  • My bad, removed the rebuild part.
    – vishad
    Commented Nov 22, 2018 at 3:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.