Databases · Middle · Question 9 of 75

Which index type fits searching inside a `jsonb` column, like `WHERE data @> '{"tags": ["sale"]}'`?

1BRIN
✓Correct answer: GIN
3B-tree

Explanation

GIN indexes the keys and elements inside a value. It's also used for arrays and full-text search. BRIN suits huge tables whose values follow physical order, like timestamps in logs.

Which index type fits searching inside a `jsonb` column, like `WHERE data @> '{"tags": ["sale"]}'`?

Explanation

Further reading

Problem with a question

Test yourself

Which index type fits searching inside a jsonb column, like WHERE data @> '{"tags": ["sale"]}'?

Explanation

Further reading

Test yourself

Which index type fits searching inside a `jsonb` column, like `WHERE data @> '{"tags": ["sale"]}'`?