COLLECT STATISTICS Examples | Teradata Vantage - Example: Collecting Full Statistics - Advanced SQL Engine - Teradata Database

Assuming that an index is defined on the empno and name columns of the employee table, the following request collects statistics for that index.

     
COLLECT STATISTICS 
        INDEX (empno, name) 
     ON employee;