1.

How Often You Should Collect Statistics For A Table?

Answer»

Analyse if it's necessary:

  • Refresh STALE STATISTICS before the batch processes run but only for tables involved in batch run.
  • Don't do it if you don't have to.
  • Oracle databse has default, scheduled job "gather_stats_job" that analyses stats on a DAILY basis during the MAINTENANCE WINDOW time.

Analyse if it's necessary:


Discussion

No Comment Found

Related InterviewSolutions