17.00 - Example: Collecting Single-Column PARTITION Statistics - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

The following examples collect statistics on the system-derived PARTITION column for the table named table_1.

Even though you have specified sampled statistics for the second example, the system ignores it and uses a value of 100 percent because you cannot collect sampled statistics on a system-derived PARTITION column. See Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .

     COLLECT STATISTICS ON table_1 COLUMN PARTITION;
     COLLECT STATISTICS USING SAMPLE table_1 COLUMN PARTITION;