PostgreSQL - JSON and JSONB
Which operator benefits most from a GIN index on a JSONB column?
Which operator benefits most from a GIN index on a JSONB column?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify operator usage with GIN
The containment operator @> is commonly used to check if one JSONB contains another, and GIN indexes optimize this.Step 2: Eliminate other operators
Equality, concatenation, and subtraction operators do not benefit as much from GIN indexes on JSONB.Final Answer:
The containment operator @> -> Option DQuick Check:
Operator optimized by GIN = @> [OK]
Quick Trick: Use @> operator with GIN indexes for fast JSONB containment queries [OK]
Common Mistakes:
- Choosing equality operator = for GIN optimization
- Confusing concatenation || with index usage
- Assuming subtraction - uses GIN index
Master "JSON and JSONB" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes