Siebel Business Process Designer Administration Guide > Performance Tuning > Tuning of Workflow Processes >

Conditions Based on Parent and Child Business Components

When a condition is being evaluated at a decision step or any other step using a combination of parent and child business components, it is recommended that you closely benchmark the expression or the condition. In some cases, this will require spooling the SQL.

NOTE:  The explain plan of the SQL might show an extended and poorly performing query. In such cases, it is better to break the conditions up into multiple decision steps and evaluate the conditions separately.

 Siebel Business Process Designer Administration Guide 
 Published: 29 May 2003