-- @tag: trigram_indices
-- @description: Trigram Indizes für häufig durchsuchte Spalten
--- @depends: release_3_5_0 shops
--- @ignore: 1
-
+-- @depends: release_3_5_0 trigram_extension
CREATE INDEX customer_customernumber_gin_trgm_idx ON customer USING gin (customernumber gin_trgm_ops);
CREATE INDEX customer_name_gin_trgm_idx ON customer USING gin (name gin_trgm_ops);