okb_index_defrag
@index_type int
Specifies which types of indexes should be evaluated
- NULL—All Index Types (default)
- 0—Heaps (Reporting only)
- 1—Clustered Indexes
- 2—Nonclustered Indexes
- 3—XML Indexes (Reporting only)
- 4—Spatial Indexes (Reporting only)
@min_depth int
Specifies how many levels the index tree must have for the index to be evaluated
- NULL—No filtering (default)
- <Num>—Index must have at least <Num> levels
@min_pages int
Specifies minimum size in 8kB pages for the index to be evaluated
- NULL—No filtering (default)
- <Num>—Index must have at least <Num> pages
@defrag_threshold numeric(5,2)
Specifies how fragmented the index must be to be defragmented
- NULL—No threshold (default)
- <Num>—Defragment index if it is at least <Num> percent fragmented
@rebuild_threshold numeric(5,2)
Specifies how fragmented the index must be to be defragmented
- NULL—Do not rebuild (default)
- <Num>—Rebuild index if it is at least <Num> percent fragmented
@limited_scan bit
Specifies whether fragmentation should be found with detailed or limited (less costly) scan of the data
- 0—Disabled (default)
- 1—Enabled
@report_only bit
If enabled the procedure will output the commands which would have been ran if this option was disabled
- 0—Disabled (default)
- 1—Enabled
