Postgres Optimization in JOIN

#Postgres #Warehouse

Join tables together starting with the smallest table (table with less cardinality) speeds things up.

To save resources, join tables together starting with the table with smallest cardinality whenever possible. Use EXPLAIN to understand the resource consumption in a query.

Published: by ;

Authors: Lei Ma

Table of Contents

Current Ref:

  • til/postgres.join-begin-with-smallest-cardinality.md