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