ADMIN_DBReindex

 Show all Hide all

Deprecated.

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

Type: Stored procedure
Area of use: General use

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