16.10 - MAP - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

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 SQL Data Definition Language - Syntax and Examples, Database Design, and Database Administration.

Syntax



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