This example collects sampled statistics on the same index as Example: Collect Statistics on a Single-Column NUSI using different syntax:
COLLECT STATISTICS FOR SAMPLE 10 PERCENT ON orders INDEX (order_date) INTO MyQCD;
This example collects sampled statistics on the same index as Example: Collect Statistics on a Single-Column NUSI using different syntax:
COLLECT STATISTICS FOR SAMPLE 10 PERCENT ON orders INDEX (order_date) INTO MyQCD;