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

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

This example collects statistics on the system-derived PARTITION column for the row-partitioned orders table and writes them to a user-defined QCD called myqcd.

Even though you have specified a sampling percentage of 30 percent, the system ignores it and uses a value of 100 percent. See Collecting QCD Statistics on the PARTITION Column of a Table.

     COLLECT STATISTICS FOR SAMPLE 30 PERCENT
     ON orders COLUMN PARTITION
     INTO myqcd;