Infix search on large table when majority of rows can be filtered out
Thank you all for your input. My colleague just solved the problem by using Trigram index on the VALUE_N columns. Now the queries run under 10ms.