Hi, I have enabled Force Case Insensitive search option in objectstore->properties->query tab.
so Ideally all the generated queries should have Lower function in where clause but when checked the database logs we observed that in some queries UPPER function is there and in some queries it is LOWER because of the queries which are using UPPER are taking lot of time. (in DB2 - Indexes are created using LOWER)

Please help me to fix this weird issue.

Regards,
Pankaj

------------------------------
Pankaj Gupta
------------------------------

Although UPPER is applied in some internally generated queries it is not applied to the database query for user searches unless that expression is used explicitly in the incoming (API) CE SQL. So these queries must be coming from some application and you would have to identity what and why. If you post the actual query you might get some help here on making that identification.

------------------------------
Mike
------------------------------