Skip Navigation
Database Indexes Take Time to Build
Answer ID 10031   |   Last Review Date 03/12/2019

Why do I see delayed impact after implementing a database index?


Custom Fields, Custom Objects, Database Indexing
All product versions


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