The procedure for creating database indexes can differ based on whether case-insensitive search behavior is in effect. Content Platform Engine implements case-insensitive search behavior in the following manner: it uses the LOWER function to convert all string column values in query statements to lowercase. For some database providers, the indexes that you create for class properties must likewise use the LOWER function.