Configuring Siebel Business Applications > Improving the Performance of Siebel Business Applications > Improving the Performance of a Siebel Application >

Improving Performance by Modifying Custom Search Specifications

You can improve performance by modifying custom search specifications.

To improve performance by modifying custom search specifications

• Examine your custom search specifications:
  • Avoid a field in the search specification that references a join.

    If a business component defines an outer join, and if a joined field that uses the outer join is included in the search specification for the business component, then the SQL generates changes to the inner join for performance reasons.

  • Avoid using a business component field that is calculated.
  • Avoid using a NOT or OR operator in the search specification. These operators force the Siebel database to execute a full table scan, which can adversely affect performance.

For more information, see Siebel Performance Tuning Guide.