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

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
vjt1596846980081.ditamap
dita:ditavalPath
vjt1596846980081.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantageā„¢

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;