How To: Exclude a table from index maintenance


To exclude a single table from all index maintenance, insert a row to the Minion.IndexSettingsTable table and set the Exclude column = 1. 

INSERT  INTO [Minion].[IndexSettingsTable]
    ( DBName ,
      SchemaName ,
      TableName ,
      Exclude           
    )
     VALUES
  ( 'YourDatabase' -- DBName
    , 'dbo'    -- SchemaName
    , 'BigTable'  -- TableName
    , 1    -- Exclude
  );