Secondary indexes provide a mechanism for specifying an additional key to the base table.

For instance, assume that an employee table containing name (employee’s name) and empno (employee number) columns is hashed on empno, but occasionally data must be retrieved based on the employee’s name rather than the employee number. You can create a secondary index on the name column of the table.