Documentation
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