About Excluding Objects from Map Reassignments - Teradata Database - Teradata Vantage NewSQL Engine

To exclude tables, join indexes, or hash indexes from the list to analyze and reassign to different maps, use procedures to create an empty list of exclusions and then add objects to it. In the following example, a DBA creates an exclusion list named 'MyExclusions' consisting of all tables in database 'Payroll', an individual table 'Employee.Withholding', and all tables in database 'Taxes' whose names begin with 'Rate'.

CALL TDMaps.CreateExclusionListSP('MyExclusions', NULL, :ExclusionListId);
CALL TDMaps.AddExclusionListEntrySP('MyExclusions', 'Payroll', NULL,:NumObjectsAdded);
CALL TDMaps.AddExclusionListEntrySP('MyExclusions', 'Employee', 'Withholding',:NumObjectsAdded);
CALL TDMaps.AddExclusionListEntrySP('MyExclusions', 'Taxes', 'Rate%', :NumObjectsAdded);