Siebel Developer's Reference > User Properties > Field User Properties >
UseExistsForSubQuery
When a user enters an EXISTS search specification, Siebel Business Applications by default generate SQL that contains an IN clause. The UseExistsForSubQuery business component user property is used to cause the EXISTS search specification on the business component to generate an SQL EXISTS clause instead.
Value |
TRUE or FALSE If set to TRUE, the SQL EXISTS clause is used when the user enters an EXISTS search specification. Is set to FALSE or if the user property is not defined on the business component, the SQL IN clause is used when the user enters an EXISTS search specification. |
Usage |
In some cases, use of the SQL EXISTS clause instead of the IN clause can improve query performance, notably on IBM DB2 390. You can inactivate this user property or modify its value. You can also create new instances of this user property, but do not create more than one instance for a single business component. |
Parent Object Type |
Field |
Functional Area |
Search |
|