Creating database indexes for class properties (case-insensitive search)

The procedure for creating database indexes differs, based on whether case-insensitive search behavior is in effect. You can use the administration console to create supporting indexes in most circumstances.

Content Platform Engine implements case-insensitive search behavior by including the LOWER function on the property and on the string value in query statements, so that the search condition becomes LOWER(property)=LOWER('Value'). However, for the following databases, the administration console cannot create supporting indexes in this way because the LOWER function is not supported on a column in an index.

For Db2® for Linux®, UNIX and Windows before 10.5, a generated column must first be created and then indexed so that the performance of the search is good.
For SQL Server, a case-insensitive collation is the default collation. If you use this collation, there is no need to enable case-insensitive search on the object store. Therefore, disable the Force case-insensitive search object store setting in the administration console. See Setting case-insensitive search behavior for object store searches.

Tip: Case-insensitive search behavior means that queries ignore character case when searching for string values. For information about setting this behavior, see Setting case-insensitive search behavior for object store searches.