15.10 - TDWMSummaryRate - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Returns the collection rate.

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

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” on page 374.

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

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