Originally posted by mrvajrala
but analyzing should be a daily one in order to provide a right feed to CBO to improve performance.
Depends on how often the characteristics of your data changes.

I was once at a site where they had about 3 years of historical data. They loaded several million rows a day, but that didn't change the characteristics of the data. They computed statistics once every 6 months.