15.10 - Example: Collecting Full Statistics - 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;