This example collects statistics on a single-column NUSI named orderDateNUPI on the order_date column from a random sample of 10 percent of the rows in the orders table and writes the statistics to the TableStatistics table of the QCD database named MyQCD.
COLLECT STATISTICS FOR SAMPLE 10 PERCENT ON orders INDEX orderDateNUPI INTO MyQCD;