Process for Changing the Map for a Table | Teradata Vantage - A Simple Process for Changing the Map for a Table - Advanced SQL Engine - Teradata Database

For example, the following request produces a list of tables that Teradata recommends use a sparse map but are now using a contiguous map:

SELECT DatabaseName, TableName FROM TDMaps.TableToSparseMapSizingV WHERE RecommendedMap LIKE '%Sparse%' AND CurrentMapKind = 'C';

The following request produces a list of tables that Teradata recommends use a different map type (either sparse or contiguous) than what they are using now:

SELECT DatabaseName, TableName FROM TDMaps.TableToSparseMapSizingV WHERE MapOk = 'N';