Flashcard
Indexes and JOIN Performance
How indexes on join columns let the planner choose efficient join strategies instead of scanning entire tables.
Question
Why does indexing the join column often change the planner's chosen JOIN strategy?
Click to reveal answer