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

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
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.