Special Cases on Collecting Statistics | Teradata Studio - Special Cases on Collecting Statistics - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities

Collecting Statistics on the PARTITION Column

PARTITION statistics are always collected for selected partitioned tables (row or column). Use the following query:
COLLECT STATISTICS COLUMN  ("col_2",PARTITION) ON "<dbname>"."<table>"

Collecting Statistics on the Global Temporary Tables

Statistics are always collected on temporary tables. Use the following query:
COLLECT STATISTICS ON TEMPORARY <table name> <keyword> (<column name>)

Limitations on Column Types

Multi-column statistics are not allowed on GEOSPATIAL column types. If any column of type GEOSPATIAL type is selected, Add Multi Column is disabled for that column.

Statistics cannot be collected on columns of Type BLOB, CLOB, XML, JSON, PERIOD and User Defined Types.