SQL: wrapping an indexed column in a function disables the index

The index stores the column's values, not the function's results. Any expression around the column forces the engine to compute it per row, which means reading every row.

Full code & output

This topic is available to PRO members.