I think the LOWER in the alias query buys us a little compared to the performance hit it costs (no index is used). The other LOWER instances are more valuable.

Comments

incidentist’s picture

incidentist commented
Assigned: Unassigned » incidentist

I turned "LOWER(dst)" into "dst" but kept the "LOWER('%%%s%%')". I think that removes the performance hit, since the alias index can be used, while still reducing capitalization issues.

incidentist’s picture

incidentist commented
Status: Active » Fixed
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.