TDWMSummaryRate Function | Application Programming Reference | Teradata Vantage - 17.05 - TDWMSummaryRate - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

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