Originally posted by KenEwald

Large Tables = Top Left
Small Tables = Bottom Right
This is true for RULE based optimisation and NESTED LOOP plans only.
For CBO this rule works not always.