16.10 - Usage Notes - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The TableToSparseMapSizingV[X] views identify which map a table should be in. For example, TableToSparseMapSizingV[X] might show that tables in a contiguous map are recommended to move to a particular sparse map. Note that the size of a table’s table header row depends on the description of the table. That information is not available to the view so an estimate is used. Because this is only an estimate, the recommended tables to move should be reviewed.

CurrentMap and RecommendedMap

CurrentMap is the map the object is currently in. RecommendedMap is the map to which the object should be moved.

CurrentMapKind

CurrentMapKind is set to C if the current map is contiguous or set to S if the current map is sparse.

CurrentMapNumOfAMPs

The number of AMPs in the map the object is currently in.

MapOk

MapOk is set to Y if the data size estimated for the table is appropriate for the map the table is currently in; otherwise MapOk is set to N.

PeakDiskSpace, CurrentDiskSpace, Datasize

PeakDiskSpace is an estimate of the amount of peak disk space all the primary rows take, determined by looking at peak space and subtracting an estimate for the table header. CurrentDiskSpace is an estimate of the amount of current disk space all the primary rows take, determined by looking at the current space and subtracting an estimate for the table header. DataSize is an estimate of the amount of space all the primary rows take considering the statistics and average row size.