cancel
Showing results for 
Search instead for 
Did you mean: 

Use of "LOWER" function in the Generated SQL statement slows down query processing significantly

Former Member
0 Kudos

Hi, I found in wiki this answer... https://wiki.hybris.com/pages/viewpage.action?pageId=35129333

It is exactly my problem... but I use MySql and not Oracle. Is there any workarround for MySql?

Kind Regards, Claudio

Accepted Solutions (1)

Accepted Solutions (1)

former_member602476
Active Participant
0 Kudos

Another option would be to set case insensitive collation on that column or table or set the case insensitive collation at the db level if it makes sense for you.

Answers (1)

Answers (1)

Former Member
0 Kudos

It also says the solution which is declare indexes on all crucial attributes.