Bookshelf Home | Contents | Index | PDF |
Siebel Developer's Reference > User Properties > Field User Properties > Using Literals Instead of Bind VariablesThe Use Literals For Like field user property uses a literal instead of a bind variable as the criteria for a LIKE predicate in the SQL code that Siebel CRM uses to query a field. The value for this user property must include one of the following values:
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 field. Guidelines for Using Literals Instead of Bind VariablesCAUTION: Avoid or minimize using the Use Literals For Like field user property. It can use resources because it requires more SQL code parsing that can cause a package cache overflow. It is recommended that you use it only after testing indicates that a significant performance improvement will result. Using the Use Literals For Like user property can impact performance when compared to using a bind variable for some searches. For example:
If you configure the Use Literals For Like field user property, then use the following guidelines:
|
Siebel Developer's Reference | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |