Using the USE INDEX HINTS and USE ESSENTIAL INDEX HINTS Parameters

This topic is part of Troubleshooting Siebel EIM Performance.

Perform testing with the IFB file parameters USE INDEX HINTS and USE ESSENTIAL INDEX HINTS, trying both settings (TRUE and FALSE). The default value for USE INDEX HINTS is FALSE. The default value for USE ESSENTIAL INDEX HINTS is TRUE.

Note: If your configuration file has more than one process section, then you must specify USE INDEX HINTS within each one.

If these parameters are set to FALSE, then Siebel EIM does not generate hints during processing. By setting the value to FALSE, you can realize performance gains if the TRUE setting means that hints are being generated that direct the database optimizer to use less than optimal indexes. Siebel EIM processing must be tested with both the TRUE and FALSE settings to determine which one provides better performance for each of the respective Siebel EIM jobs.

Note: The USE INDEX HINTS parameter is applicable only for Oracle Database. The USE ESSENTIAL INDEX HINTS parameter is applicable only for Oracle Database and Microsoft SQL Server.

These two parameters work for different queries, so you have to enable both to get all of the index hints on Oracle Database.

Further information is provided as follows:

• Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Example

• Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Criteria for Passing Indexes to the Database