Which PostgreSQL data type can a GIN index be used on to speed up containment queries?

easy📝 Conceptual Q2 of 15

PostgreSQL - Indexing Strategies

AINTEGER and BIGINT types

BTEXT and VARCHAR types

CJSONB and array types

DDATE and TIMESTAMP types

Step-by-Step Solution

Solution:

Step 1: Identify data types supported by GIN
GIN indexes are commonly used on JSONB and array types to speed up containment and membership queries.
Step 2: Eliminate other types
Text and numeric types are usually indexed with B-tree, not GIN; date/time types also use B-tree.
Final Answer:
JSONB and array types -> Option C
Quick Check:
GIN index supports = JSONB and arrays [OK]

Quick Trick: Use GIN for JSONB and arrays, not simple types [OK]

Common Mistakes:

Master "Indexing Strategies" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free