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 is set to C if the current map is contiguous or set to S if the current map is sparse.
The number of AMPs in the map the object is currently in.
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.