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;