TDWMSummaryRate Function | Application Programming Reference | Teradata Vantage - TDWMSummaryRate - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
cpn1571792172880.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Returns the collection rate.

Definition

REPLACE FUNCTION TDWM.TDWMSummaryRate ()
RETURNS SMALLINT
          .
          .
          .
;

Usage Notes

Use the SetSessionRate function to set the collection rate for updating session-level statistics within memory.

The TDWMSummaryRate function provides similar functionality to a TDWM Summary request. For more information about this interface, see TDWM SUMMARY.

Return Value

The TDWMSummaryRate function returns the duration of the collection period in seconds. This value represents the collection rate.

Example: Using TDWMSummaryRate

SELECT TDWM.TDWMSummaryRate();
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 3 seconds.
TDWMSummaryRate()
-----------------
               60