Example: Collect Statistics on a Single-Column NUSI - Teradata Database - Teradata Vantage NewSQL Engine

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 them to the TableStatistics table of the QCD database named MyQCD.

     COLLECT STATISTICS FOR SAMPLE 10 PERCENT
     ON orders INDEX orderDateNUPI
     INTO MyQCD;