17.10 - MAP - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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
The AMPs in the map (or, for a sparse map, the AMPs in the parent map) store the rows of tables and join indexes that use the 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