16.20 - Advisor Procedures - 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)

The Advisor procedures analyze tables and recommend which tables to move to specific maps. The procedures are helpful for moving large- and medium-sized tables from one contiguous map to another. The procedures are also helpful for moving small tables to a sparse map.

Advisor decides whether to move sets of tables to the destination map as a group, analyzing the table size, and makes recommendations on moving small tables to sparse maps.