Siebel Configuration Guidelines for Performance

•  Always evaluate and add index on columns used in joins, sort and search specifications
•  Avoid using sort specifications on non-indexed columns or joined columns
•  Limit the use of case insensitivity for queries
•  Avoid overly complex user interface configuration
•  Limit the number of business components in a view
•  Limit the number of virtual business components in a view
•  Limit the number of records returned
•  Limit the number of joins, extension tables, and primary ID fields in a business component
•  Use inner joins rather than outer joins
•  Remove unneeded sort buttons
•  Provide tuned PDQs
•  Avoid calculated fields that do Counts and Sums