PGSQL tableA like '% a %' or tableB like '% a %' query time is too long
With mysql solution can also draw lessons from

CodePudding user response:

Mysql how to solve this situation

CodePudding user response:

Traditional way: tableA like 'a %' or tableB like 'a %' column and indexed

PGSQL another solution: create index of GiST