How To: Configure settings for a single table



Default settings are stored in the Minion.IndexSettingsDB table. To specify settings for a specific table that override those defaults (for that table), insert a row for that table to the Minion.IndexSettingsTable table. For example: 




INSERT  INTO [Minion].[IndexSettingsTable]
    ( [DBName] ,
      [SchemaName] ,
      [TableName] ,
      [Exclude] ,
      [ReindexGroupOrder] ,
      [ReindexOrder] ,
      [ReorgThreshold] ,
      [RebuildThreshold] ,
      [FILLFACTORopt] ,
      [PadIndex] ,
      [ONLINEopt] ,
      [SortInTempDB] ,
      [DataCompression] ,
      [GetRowCT] ,
      [GetPostFragLevel] ,
      [UpdateStatsOnDefrag] ,
      [LogIndexPhysicalStats] ,
      [IndexScanMode] ,
      [LogProgress] ,
      [LogRetDays] ,
      [IncludeUsageDetails]

    )
VALUES  ( 'YourDatabase' , -- DBName
    'dbo' ,    -- SchemaName
    'YourTable' ,  -- TableName
    0 ,    -- Exclude
    0 ,    -- ReindexGroupOrder
    0 ,    -- ReindexOrder
    10 ,    -- ReorgThreshold
    20 ,    -- RebuildThreshold
    80 ,    -- FILLFACTORopt
    'ON' ,    -- PadIndex
    NULL ,    -- ONLINEopt
    NULL ,    -- SortInTempDB
    NULL ,    -- DataCompression
    1 ,    -- GetRowCT
    1 ,    -- GetPostFragLevel
    1 ,    -- UpdateStatsOnDefrag
    0 ,    -- LogIndexPhysicalStats
    'Limited' ,  -- IndexScanMode
    1 ,    -- LogProgress
    60 ,    -- LogRetDays
    1    -- IncludeUsageDetails
   );