Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete Old Stats?

459893Sep 26 2012 — edited Sep 26 2012

Hello Gurus,

Say for example, I gather schema statistics twice a week on my database (11.2.0.3)

Is it a best practice to Delete Old Statistics before I gather new statistics? If I don't, what happens to the old statistics once the new one is generated?

Thanks and Regards,
Lily

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2012

Added on Sep 26 2012

#general-database-discussions

4 comments

767 views