The statistics management templates help you keep statistics current, so you can generate efficient query plans.
Sybase update statistics template This template uses the update statistics command to allow you to update statistics at the table, column, and index levels. Additionally, you can provide threshold values for page count and row count.�
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.�
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
