16.20 - SYSLIB.SparseMapAMPs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)


SYSLIB.SparseMapAMPs is a table function that returns the AMPs with a sparse map defined for a table, join index, or hash index.

The view DBC.SparseMapAMPsV is an alternative to using the table function SYSLIB.SparseMapAMPs. The underlying system view, DBC.ObjectsInSparseMapsV, prepares all arguments for the table function. See Teradata Vantage™ - Data Dictionary, B035-1092 for more details about views DBC.SparseMapAMPsV and DBC.ObjectsInSparseMapsV.


Name of the database where the function is located.
The database in which the object is defined.
Name of the table, join index, or hash index defined in 'DatabaseName'. It cannot be NULL.
The kind of objects, such as a table, join index or hash index, defined in the sparse map.
The map slot of the sparse map.
If the map containing the map slot does not exist, or is not a sparse map, an error is returned.
The number of primary AMPs defined in the sparse map.
The colocation name string for the table.