ADMIN_DBReindex

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Stored procedure

Massages chosen indices in the database to thwart defragmentation issues from affecting database performance. Suitable to run as an SQL-job.

Parameters

@FillFactor optional int
In percent (0-100) how high the fill factor for the index should be, NULL for keeping the existing setting. Default value: 80
@FragmentationLimit optional int
In percent (0-100) how high the logical fragmentation must be before an index is reindexed, NULL to include all indices. Default value: 10