Modifying Custom Search Specifications

You can improve performance by modifying custom search specifications.

To modify 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 the Search Specification property of a business component includes a joined field that uses this outer join, then the SQL code modifies 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 run a full table scan that can adversely affect performance.

For more information, see Siebel Performance Tuning Guide.