Options for Flushing the DBQL Cache - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Options for Flushing the DBQL Cache

Before Teradata Database writes DBQL data to Data Dictionary tables, it holds the data in cache until either:

  • The cache is full.
  • You end query logging.
  • The number of seconds has elapsed that you define in the DBS Control utility field DBQLFlushRate.
  • Note: You can select a rate from 1 to 3,600 seconds. However, Teradata recommends a flush rate of at least 10 minutes (600 seconds), which is the default. Less than 10 minutes can impact performance.

  • You flush the DBQL cache manually.