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 |