02 – GIN Index on JSONB

Theory

Index Creation

When GIN works

When GIN does NOT work

Task

Full Working Code

`src/main/resources/db/migration/V2addmetadataindex.sql`

`src/test/java/com/example/demo/repository/JsonbGinIndexTest.java`

Expected Output

EXPLAIN plan for `@>` operator:

Test output:

Verification Steps