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.

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window