AnalyzeSP Syntax - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

CALL [TDMaps.] AnalyzeSP (
  'DestinationMapListName',
  'ObjectListName',
  'ExclusionListName',
  [ { 'LogStartTime' | NULL } , ]
  [ { 'LogEndTime' | NULL } , ]
  { 'LogDatabase' | NULL },
  'OutputActionList',
  :NumAlters,
  :NumExcludes,
  :NumLogEntries
) [;]

Syntax Elements

TDMaps.: The name of the database.
DesintationMapListName: The name of an existing map list for recommending table actions on.
ObjectListName: Name of the object list.
ExclusionListName: Specifies the objects to skip analysis in the exclusion list.
LogStartTime: Limits query log to queries logged after a specified time.
LogEndTime: Limits query log to queries logged before a specified time.
LogDatabase: The database containing the query log tables.
OutputActionList: The name to assign to a list of table actions recommended by a procedure call.
NumAlters: The number of rows written to TDMaps.ActionsTbl where Action = ALTER.
NumExcludes: The number of rows written to TDMaps.ActionsTbl where Action = EXCLUDE.
NumLogEntries: The number of analyzed logged queries that reference one or more tables in the ObjectListName.