Nov
18

Sybase T-SQL: How to keep your indexes up-to-date with update statistics

MDBitz - Matthew Denton T-SQL Add you comment

After inserting, modifying, or deleting a large amount of records in a table that contains indexes performance of queries can be increased by use of the update statistics query. The update statistics query creates or replaces statistics on a column and stores them in the system tables systabstats and sysstatistics. Sybase utilizes these statistics when determining how to process a query.

Examples:

Updating all indexes of a Table

UPDATE STATISTICS T_USERS -- T_USERS = table name

Updating a single index of a Table

UPDATE STATISTICS T_USERS user_pk_idx -- user_pk_idx = index name

Resources:

,