Show all
Hide 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