## Utility to check Table Fragmentation, index type/fillfactors/#of rowsOctober 10, 2003
RPT_INDEXEVAL -- if no parameters are entered, shows index and fragmentation for every table in DB (to include statistics) -- if parameters are entered, shows certain tables/indexes based on criteria @LessThanScanDensity = null -- bit value (show less than @ScanDensityValue entered) -- NULLABLE value ,@ScanDensityValue = null -- int value (Scan Density to show; if @LessThanScanDensity = 1 (show less than this value)) -- Optimal value for each index is 100%, less indicates some fragmentation -- NULLABLE value ,@GreaterThanLogicalScan = null -- bit value (show greater than @LogicalScanValue entered) -- NULLABLE value ,@LogicalScanValue = null -- int value (Logical Scan to show; if @GreaterThanLogicalScan = 1 (show less than this value)) -- Optimal value for each index is 0%, more indicates some fragmentation -- NULLABLE value ,@GreaterThanExtentScan = null -- bit value (show greater than @ExtentScanValue entered) -- NULLABLE value ,@ExtentScanValue = null -- int value (Extent Scan to show; if @GreaterThanExtentScan = 1 (show less than this value)) -- Optimal value for each index is 0%, more indicates some fragmentation -- NULLABLE value NOTE: Resultset is sorted based on ScanDensity DESC, LogicalScan ASC, ExtentScan ASC Author: Chris
Back to |