Ask the Expert

Deleting statistics after analyzing tables

Do you have to delete statistics after analyzing all the tables? Any help is appreciated.

    Requires Free Membership to View

The short answer would be: if you are done with the statistics, and you need to manage your available storage capacity, and you can reproduce the statistics, and you don't need to retain a history of those statistics, then deleting them seems prudent. Hoever, I can't give you an informative answer to this question without more context. What type of statistics (domain distribution, table capacity, usage, read/load/exception)? What kind of analysis are you referring to (source content analysis, target table acceptance testing analysis)? What tables, staging tables, source tables, target tables?

For More Information


This was first published in November 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: