How can you combine a GIN index on full-text search with a filter on a category column to optimize queries?

hard📝 Application Q9 of 15

PostgreSQL - Full-Text Search

How can you combine a GIN index on full-text search with a filter on a category column to optimize queries?

ACreate a single BTREE index on both columns

BCreate two separate GIN indexes on to_tsvector and category

CCreate a BTREE index on to_tsvector and GIN on category

DCreate a composite index: GIN on to_tsvector and BTREE on category

Step-by-Step Solution

Solution:

Step 1: Understand index types for each column
Use GIN for full-text search column and BTREE for category filtering.
Step 2: Create a composite index combining both
PostgreSQL supports multicolumn indexes mixing GIN and BTREE.
Final Answer:
Create a composite index: GIN on to_tsvector and BTREE on category -> Option D
Quick Check:
Composite GIN + BTREE index optimizes both filters [OK]

Quick Trick: Combine GIN and BTREE in one index for text + filter [OK]

Common Mistakes:

Master "Full-Text Search" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free