Example: Showing Cylinders in TIM Cache - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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