The query must use the same expression to benefit. It fixes non-sargable conditions without rewriting data.
Expression index
An index built on the result of an expression such as lower(email) instead of a plain column.
The query must use the same expression to benefit. It fixes non-sargable conditions without rewriting data.