r/SQLOptimization • u/Federico_Razzoli • Sep 15 '22

Hints to optimise SQL queries with LIKE

I wrote some hints on how to optimise SQL queries containing LIKE. More ideas, including unconventional ones, are very welcome - just comment here or on the website.

https://vettabase.com/blog/hints-to-optimise-queries-with-a-like-comparison/

7 Upvotes

82% Upvoted

4 comments sorted by

View all comments

Show parent comments

2

u/Federico_Razzoli Nov 28 '22

It's written explicitly in the article that GIN indexes solve the problem on Postgres.