Reorganize indexes in table

Name:	Reorganize indexes in table
Platform:	Sqlserver
Category:	Maintenance
Description:	Reorganizing fragmented indexes in all tables listed in the ‘table list’ parameter.
Long description:	Reorganizing an index uses minimal system resources. It defragments the leaf level of clustered and nonclustered indexes on tables and views by physically reordering the leaf-level pages to match the logical, left to right, order of the leaf nodes. Reorganizing also compacts the index pages. Compaction is based on the existing fill factor value.
Version:	1.2
Default schedule:	5 21 6 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ \| engine_edition = ‘Azure SQL Managed Instance’)

Feedback