Is having the auto create statistics on in a database a good thing?

585 pts.
Tags:
SQL Server 2005
SQL Server administration
SQL Server performance
Hello I have a 250GB database and the auto create statistics is on is that a good thing?

Software/Hardware used:
sql server 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

Generally you want the statistics to be automatically created and maintained.
There are exceptions – if your database is routinely updated by a high-volume batch update, you might want to disable statistics during the update and then turn them on after the update completes.
Otherwise, maintaining the statistics helps the query optimizer to properly execute the queries. This is true for all database engines.
If your statistics get “stale” the query optimizer may execute queries in a non-optimal manner, possibly leading to table scans and other performance-killing strategies.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following