Bookshelf Home | Contents | Index | PDF |
Siebel Enterprise Integration Manager Administration Guide > EIM Performance Tuning > Troubleshooting EIM Performance > USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: EIM Criteria for Passing Indexes to the DatabaseThis topic explains how EIM determines which indexes to include on the hint clause passed to the database when using the USE INDEX HINTS and USE ESSENTIAL INDEX HINTS parameters. When determining which indexes to pass on to the database as index hints, EIM takes the following steps:
EIM uses the following selection criteria in choosing indexes:
If a new index is created and it is declared in the repository, then there is a chance that EIM will choose it and pass it to the database on a hint. NOTE: Regarding the behavior of the Oracle optimizer, when you specify an INDEX hint, the optimizer knows that it must use the index specified in the hint. In this case, the optimizer does not perform a full table scan, nor does it use any other index. |
Siebel Enterprise Integration Manager Administration Guide |