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;
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;