16.20 - TDWMSummaryRate - Teradata Vantage NewSQL Engine

Teradata Vantage™ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

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