Re:Speeding up SQL queries by orders of magnitude using UNION
by candu on Monday March 22, 2021 @09:18AM
(#26540356)
> unless an alternative sargable predicate is too complex or not possible...
As you note, functional indexes can sometimes be the best solution - some common examples: when working with different geospatial projections in PostGIS; when building a full-text index using `to_tsvector`. For anyone who works with relational databases that support this, definitely a good tool to have in your toolkit!
As you note, functional indexes can sometimes be the best solution - some common examples: when working with different geospatial projections in PostGIS; when building a full-text index using `to_tsvector`. For anyone who works with relational databases that support this, definitely a good tool to have in your toolkit!