News for hackers. Stuff that matters.

A comment on Can adding an index make a non SARGable query SARGable?. Parent comment

Re:Can adding an index make a non SARGable query SARGable? by mlyle on Friday October 18, 2019 @09:23PM (#21296252)
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..)
[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by ComputerGuru on Saturday October 19, 2019 @12:21AM (#21296738)
SQLite does this too out of the box, though many GUI tools struggle to cope with tables created in that fashion.
[ Parent | on HN ]