SQL Queries

Use the following guidelines to improve the SQL query performance of PSP:

• Minimize the number of SQL queries executed. Consolidate multiple Simple Look-Up steps into one step if the steps use data from the same reference data business component with the same search specification.

• Tune SQL queries by:

  • Querying through thin business components to minimize Siebel Object Manager overhead and reduce query complexity.

  • Making sure that all search specifications have index coverage.