|
Siebel Developer's Reference > User Properties >
UseExistsForSubQuery
When a user enters an EXISTS search specification, Siebel 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 create new instances of this user property, but you should not create more than one instance for a business component. |
Parent Object Type |
Field |
Functional Area |
Search |
|
