Usage Notes - Advanced SQL Engine - Teradata Database

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynt1557098768177.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantageā„¢
  • To run this macro with CollectSummaryStats ('Y'), the SystemFE user needs the SELECT and STATS privileges on InputDatabaseName.

    SELECT lets the user check whether the statistics are stale and STATS lets the user collect statistics on objects.

  • CollectSummaryStats ('Y') increases the accuracy of the CDS values that the macro returns for the database. However, if the statistics are stale or not already collected for InputDatabaseName, the macro must collect new statistics, which increases macro running time.