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
------------------------------