Configuring Siebel Business Applications > Improving the Performance of Siebel Business Applications > Improving the Performance of a Siebel Application >
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.
|