SYSLIB.SparseTableAMPs Function | SQL Operators & UDFs | Teradata Vantage - SYSLIB.SparseTableAMPs - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
qqu1556127655717.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

SYSLIB.SparseTableAMPs is a function that returns the AMPs on which a table, join index, or hash index with a sparse map is defined.

Syntax

[SYSLIB.] SparseTableAMPs (
  'DatabaseNameString',
  'ObjectNameString'
)
SYSLIB.
Name of the database where the function is located.
'DatabaseNameString'
The name of the database. The data type is VARCHAR(128).
'ObjectNameString'
The name of a table, join index, or hash index. The data type is VARCHAR(128).