17.05 - Example: Collecting Multi-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 multi-column sampled statistics on the following column set for the row-partitioned orders table and writes them to a user-defined QCD called myqcd:

  • System-derived PARTITION column
  • quant_ord
  • quant_shpd

Because you are requesting multicolumn statistics, the system honors the specified sampling percentage of 20 percent, unlike the case for single-column PARTITION statistics. See Collecting QCD Statistics on the PARTITION Column of a Table and Example: Collect Statistics on a Single-Column NUSI.

     COLLECT STATISTICS FOR SAMPLE 20 PERCENT
     ON orders COLUMN (quant_ord, PARTITION, quant_shpd)
     INTO myqcd;