17.10 - Example: Showing Cylinders in TIM Cache - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

The following example shows the cylinders of the BASIC_INFO table that are in TIM cache.

Database Name Table Name StartTable

IdType

AndIndex

Temp Normalized TempInfo Very Hot Candidate Very Hot Cache % Full
DBC ALL 0 120.99 HOT Y Y 31.6
TD_

SYSFNLIB

TO_TIMESTAMP 0 102.38 WARM Y Y 81.28
DBC UDFINFO 0 101.29 WARM Y Y 11.98
DBC UDFINFO_TD14 0 91.42 WARM Y Y 52.93
EMPLOYEE BASIC_INFO 1,024 86.27 WARM Y Y 90.72
EMPLOYEE BASIC_INFO 1,024 29.41 WARM Y Y 90.72
EMPLOYEE BASIC_INFO 1,024 18.67 WARM Y Y 90.14
EMPLOYEE BASIC_INFO 1,024 18.11 WARM Y Y 90.24
EMPLOYEE BASIC_INFO 1,024 18.11 COLD Y Y 90.1
EMPLOYEE BASIC_INFO 1,024 18.06 COLD Y Y 90.64
EMPLOYEE BASIC_INFO 1,024 18 COLD Y Y 90.17
EMPLOYEE BASIC_INFO 1,024 17.75 COLD Y N 90.48
EMPLOYEE BASIC_INFO 1,024 17.73 COLD Y N 90.32
EMPLOYEE BASIC_INFO 1,024 17.73 COLD Y N 90.62
EMPLOYEE BASIC_INFO 1,024 17.72 COLD Y Y 90.26
EMPLOYEE BASIC_INFO 1,024 17.72 COLD Y Y 90.18