increase speed of like queries postgres 1

increase speed of like queries postgres

CREATE INDEX tbl_col_gin_trgm_idx  ON tbl USING gin  (col gin_trgm_ops);

Here is what the above code is Doing:
1. Create a table called tbl with a column called col.
2. Create a gin index on the column col using the gin_trgm_ops operator class.

Similar Posts