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
);