Term Kind Topic What it is
Cardinality Estimation concept Query Optimisation The planner's prediction of how many rows each step of a query will produce — the input that determines every other choice it makes.
Join Strategies concept Query Optimisation The three ways a database combines two row sets — nested loop, hash join and merge join — and the conditions under which each is correct.