Siebel Performance Tuning Guide > Tuning Siebel Workflow for Performance > Tuning Workflow Processes >

Monitoring 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. For more information, see Analyzing Generated SQL for Performance Issues.

NOTE:  The query 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 Performance Tuning Guide Copyright © 2006, Oracle. All rights reserved.