Why do I see delayed impact after implementing a database index?
Environment:
Custom Fields, Custom Objects, Database Indexing
All product versions
Resolution:
The time it takes to build a database index is dependent on the data in the database and table, the hardware in use, the current load on the database, and other factors such as the nature of the index. For this reason it can be expected to not see performance change in the system immediately after the implementation of a database index.
For further information on the subject of database indexing as it applies to Oracle B2C Service see
Answer ID 1266: Impact of indexing a custom field
Answer ID 8618: Creating Indexes on a custom object
Answer ID 8702: Working with Technical Support to analyze and implement database indexes
Answer ID 8455: Poor performing query - too many rows examined