例: サブテーブルの種類の異なるテーブルを示すヒートマップ レポート - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL演算子およびユーザー定義関数
Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/fsi1592016213432.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1210
Product Category
Software
Teradata Vantage

次の例では、異なるサブテーブル型を持つテーブルを示すヒートマップ レポートを表示しています。レポートでは、'EMPLOYEE.BASIC_INFO'のプライマリFALLBACKサブテーブル(2048)とSECONDARY INDEXサブテーブル(1028)、およびそのプライマリ永久テーブルが示されます。

The Date The Time Amp No Database Name Table Name Start

Table

Id

Uniq

 Start

Table

Id

Type

AND

Index

 End

Table

Id

Uniq

 End

Table

Id

Type

AND

Index*

 Cyl Id Temp Normalized Temp Info
9/24/2015 0:38:19 2 DBC ALL 00-00- 00-00 0 00-00- 38-01 0 00-06- 00-02-00- 00-00-20 266.23 HOT
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-55 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-56 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-61 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-63 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00-A8-0A 2,048 00-06- 00-02-00- 00-00-6B 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00-A8-0A 2,048 00-06- 00-02-00- 00-00-58 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00-A8-0A 2,048 00-06- 00-02-00- 00-00-57 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-60 252.42 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00-A8-0A 2,048 00-06- 00-02-00- 00-00-65 252.41 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00-A8-0A 2,048 00-06- 00-02-00- 00-00-5A 252.41 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-59 17252.41.75 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-62 252.41 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-64 252.41 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- SE-0D 1,024 00-06- 00-02-00- 00-00-53 252.36 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-6F 252.34 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 2,048 00-00- A8-0A 2,048 00-06- 00-02-00- 00-00-6D 252.34 WARM
9/24/2015 0:38:19 2 DBC DBQLRULETBL 00-00- 4C-01 0 00-00- 54-07 0 00-06- 00-02-00- 00-00-4A 226.45 WARM
9/24/2015 0:38:19 2 DBC TVM 00-00- 38-01 1,024 00-00- 48-01 2,052 00-06- 00-02-00- 00-00-1F 218.82 WARM
9/24/2015 0:38:19 2 TD_SYSFNLIB ARRAY_MUL_B 00-00- 55-07 0 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-48 73.75 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 1,024 00-00-A8-0A 1,028 00-06- 00-02-00- 00-00-37 37.09 WARM
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00- A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-40 35.72 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-4C 35.55 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00- A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-3C 20.88 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00- A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-41 20.58 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-4B 20.46 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-54 20.02 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00- A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-3B 19.97 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00-A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-49 19.96 COLD
9/24/2015 0:38:19 2 EMPLOYEE BASIC_INFO 00-00- A8-0A 1,024 00-00- A8-0A 1,024 00-06- 00-02-00- 00-00-3F 19.95 COLD