medium10 pts · first answer countsindexingpostgresql

Searching inside text

Users search product names with WHERE name ILIKE '%phone%'. The B-tree index on name is not used. What is the best PostgreSQL option?

A.Create a GIN index using pg_trgm (gin_trgm_ops) on nameB.Create a second B-tree index on name DESCC.Use a hash index on nameD.Increase random_page_cost

← Indexing only pending rows Fast JSONB filters →