17.00 - 17.05 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)
  • To run this macro with CollectSummaryStats ('Y'), the SystemFE user needs the SELECT and STATS privileges on all databases in the system.

    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 system. However, if the statistics are stale or not already collected for database objects, the macro must collect new statistics, which increases macro running time.