DBQL Enhancements | Advanced SQL Engine 17.00 | Teradata Vantage - 17.10 - DBQL Enhancements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Release Summary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1098-171K
Language
English (United States)

The Database Query Log (DBQL) is enhanced for Advanced SQL Engine 17.00 with more complete and more accurate logging.

Benefits

  • DBQL now uses Algorithm 3 by default, which includes collecting statistics on aborted and parallel steps, and results in more accurate resource usage statistics.
  • By default, Vantage now logs the number of SUM and JOIN steps at the request level to gauge query complexity.
  • The DBQL default behavior now is to include Feature Use Logging (FUL).

Considerations

  • Upgraded systems that were not using Algorithm 3 will not use Algorithm 3 until explicitly set to do so. This requires that you explicitly change DBS Control General field 64, DBQL CPU/IO Collection. Teradata recommends you switch to using Algorithm 3.

Additional Information

  • For more information about DBQL, see Teradata Vantage™ - Database Administration, B035-1093.
  • For more information about the DBS Control utility, see Teradata Vantage™ - Database Utilities, B035-1102.