Check and update optimizer statistics

[Former Member]

what is the use of check and update optimizer statistics in db13

[former_member204746]

Rajesh, a simple Google search would have given you the answer.

Please search before asking questions.

I am locking this topic.

[former_member524429]

Hi,

"check and update optimizer statistics" job in db13 will check all tables of the database to see if the statistics are out of date

and will update the statistics if required.

The DB Optimizer find the optimal access path for the SQL query in Execution. The DB Optimizer relies on the Statistics of Tables. If the Statistics are not up to date (and When the Table grows with big size) then the DB might use more expensive access path upon execution of SQL query on such Tables, and will result in poor performance.

This Job should be run on weekly basis or based on your daily DB growth rate.

Regards,

Bhavik G. Shroff