Specifying the SQL for EXISTS Search Specifications

The UseExistsForSubQuery field user property determines the type of SQL clause that Siebel CRM uses if it encounters an EXISTS search specification in a business component. If it encounters an EXISTS search specification, and if the value for this user property is:

• TRUE. Siebel CRM uses the SQL EXISTS clause.

• FALSE or this user property does not exist. Siebel CRM uses the SQL IN clause.

In some situations, using the SQL EXISTS clause instead of the IN clause can improve query performance, particularly for IBM DB2 390.

You can configure Siebel CRM to deactivate this user property, to modify the value for it, or to create a new instance of it, but no more than one instance for a single business component.