Example: Collecting Multi-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 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;