I have a ODS which has 2 field as key. I would like to know if this ods table is automatically indexed or is there a way to index the ODS.
Bhanu Gupta replied
The primary index is created automatically when the table is created in the database. The primary index contains the key fields of the table and a pointer to the non-key fields of the table. You create secondary indexes if required.
Hope this helps...