Provides information about a specified contiguous or sparse map.
Maps determine how table (and join index table) data is distributed among AMPs. You can assign a map to a table when you create or alter a table. Maps can be either contiguous or sparse. For more information about maps, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144, Teradata Vantage™ - Database Design, B035-1094, and Teradata Vantage™ - Database Administration, B035-1093.
Syntax
MAP "mapname"
Syntax Elements
- mapname
- The name of the map for which you want information.
Usage Notes
The map information includes:
- whether the map is contiguous or sparse
- if the map is contiguous, whether it is the system default contiguous map
- the map number (indicated as MAP ID in the display)
- if the map is sparse, the base (parent) contiguous map name
- range of AMPs in the contiguous or base contiguous map
Examples: MAP command
The following examples demonstrate the MAP command output for contiguous and sparse maps.
==> >map "SparseMap1" map "SparseMap1" Map Name : SPARSEMAP1 Map Type : Sparse Map ID : 1046 (0x416) Base Contiguous Map Name : TD_MAP1 Contiguous Map AMP Range : 0-99 ==> > map "td_map1" map "td_map1" Map Name : TD_MAP1 - The Default Map Map Type : Contiguous Map ID : 1025 (0x401) Contiguous Map AMP Range : 0-99 ==> > map "td_map4" map "td_map4" Map Name : TD_Map4 Map Type : Contiguous Map ID : 370 (0x0172) Contiguous Map AMP Range : 50-99