The statistics management templates help you keep statistics current, so you can generate efficient query plans.
Sybase server update statistics template This template uses the update statistics command to allow users to update statistics on all tables in all server databases. The template allows you to supply values for the various options of the update statistics command, while the table, column, and index values are retrieved from the system tables.
Additionally, you can provide threshold values for data change, page count, and row count. If you supply any of these optional values, they will be used as a gauge in determining whether the update statistics command should be run. If current values for any one of these thresholds meet or exceed the threshold for a given table, update statistics will be executed on that table. After update statistics is run, the sp_recompile procedure is run for the table.
Sybase update statistics template This template uses the update statistics command to allow you to update statistics at the table, partition, column, and index levels. Additionally, you can provide threshold values for data change, page count, and row count. Data change is a metric that allows you to track the amount of changes to a table, column, or partition. You can use it as an indicator that the update statistics command might help improve performance.
If you provide threshold values, they determine if the update statistics command should be run. After update statistics is run, the sp_recompile procedure is run for the table you specified in the template wizard.
Sybase delete statistics template This template uses the delete statistics command to allow you to delete statistics for all columns in the specified table, for a specific column in the table, or for a partition and local indices on a partition. You must supply the database and table name. You can also specify a column list of which statistics you want to delete. If the column list is omitted, statistics for columns in the entire table are deleted.
