Indexes are created on the table to improve performance. The purpose of adding index is to help the database locate records much quickly and efficiently. The steps needed in adding an index to a Siebel table are pretty straight forward but this has to be first done on the local client db using Siebel Tools and should never be done straight on the database.
For the purpose of this blog, I will take an example of adding an index to an extension column s_org_ext.X_OLD_ACC_NUM. (more…)
