Unit of Time - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

The unit of time for n.

CPUTIME
n as AMP CPU time, where n represents hundredths of a second.
CPUTIMENORM
n as normalized AMP CPU time, where n represents hundredths of a second.
ELAPSEDSEC
n as elapsed time in seconds.
ELAPSEDTIME
n as elapsed time, in hundredths of a second. This is the default.
IOCOUNT
n as a count of total I/Os, where n is specified in the number of I/Os.