Comment by anthonyIPH

Comment by anthonyIPH 11 hours ago

2 replies

"Instead you should:

query WHERE name = ‘abc’

create an indexed UPPER(name) column"

Should there be an "or" between these 2 points, or am I missing something? Why create an UPPER index column and not use it?

karmakaze 10 hours ago

[and a third] OR use a case-insensitive collation for the name column.

MiscCompFacts 6 hours ago

I think they reversed the 2 expressions. You should use “WHERE UPPER(name) = ‘ABC’” if you want to use the index.