Skip to main content

inverted join

Short Description

An inverted join forces the optimizer to use a Generalized Inverted Index (GIN index) on the right side of the join

Detailed Description

An inverted join force the optimizer to use a Generalized Inverted Index (GIN index) on the right side of the join. GIN indexes are used on container columns such as:

  • JASONB documents
  • Arrays
  • Spatial Data

INVERTED JOINs can only be used with INNER and LEFT joins.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.