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
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
vnq1596660420420.ditamap
dita:ditavalPath
hoy1596145193032.ditaval

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;