4 ms·
A lot of people are used to Postgres where you can create an index on the expression itself, and then it's cheap to seek or order on that expression. (Common o
by mlyle 7y ago
A lot of people are used to Postgres where you can create an index on the expression itself, and then it's cheap to seek or order on that expression. (Common ones are things like this-- substrings, date expressions, uppercasing of things..)
- ComputerGuru 7y agoSQLite does this too out of the box, though many GUI tools struggle to cope with tables created in that fashion.