Examples | Temperature, Cylinder, Heatmap Data | Teradata Vantage - Example: Data Temperature Report Showing a Specific Table - Advanced SQL Engine - Teradata Database

SELECT * FROM demo.tdheatmap_v WHERE DatabaseName = ‘EMPLOYEE’ AND TableName = ‘BASIC_INFO’ ORDER BY Temperature DESC

1. The cylinder belongs to a primary permanent table:

   StartTableIdTypeAndIndex = 1024

2. TIM is not enabled:

   VeryHotCandidate = BLANK

   and

   VeryHotCache = BLANK

   and

   TempVeryHotFloor = 0

3. This cylinder is not a mixed cylinder:

   StartTableIdUniq = 0000A80A

   and

   EndTableIdUniq = 0000A80A

   If it is a mixed cylinder, StartTableIdUniq and EndTableIdUniq shows different values.
4. This heatmap was taken from AMP 1:

   AmpNumber = 1

5. This table is not partitioned:

   StartPartition = 0

   and

   EndPartition = 0