Collecting Statistics on Data Dictionary Tables - Teradata Vantage

If you are using custom applications or business intelligence tools, you may want to collect statistics on Data Dictionary tables, because these applications and tools often query the Data Dictionary for validation or information checks in the background.

Components within Vantage use internal express requests that are optimized single-AMP queries. Statistics on Data Dictionary tables do not benefit these internal activities but benefit SQL submitted directly by a user or an application.

The value of collecting statistics on dictionary tables depends on the frequency and complexity of the queries that access the dictionary tables, the amount of resource the queries use, and how long the queries run on your platform. Using DBQL can help determine the benefit, but requires the DBC logon to collect against Data Dictionary tables. To decide whether to collect statistics on Data Dictionary tables, examine the DBQL output to determine if your applications use significant resources to access the Data Dictionary.

For more information, see https://downloads.teradata.com/blog/carrie/2010/05/if-you-re-not-collecting-statistics-on-your-dictionary-tables-do-it-now.