Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Developer's Reference > User Properties > Field User Properties > Specifying the SQL for EXISTS Search SpecificationsThe 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:
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. |
![]() ![]() |
Siebel Developer's Reference | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |