Can u please tell me how to create a secondary index for a table......
Explain me briefly please....
The secondary index is automatically created in the database during activation if the corresponding table was already created there and index creation was not excluded for the database system.
Usage -> Secondary Index is created by specifying a field. and if you want to select a data from this table by specifying this field in you selection criteria.