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.