Trust optimizer usually. Override only with evidence. Keep statistics updated. Index join columns. Filter early with WHERE.

Update table statistics regularly

Index all join columns

Filter early with WHERE

Join smaller tables first when forcing order

Use covering indexes

Test different approaches with EXPLAIN

Forcing join order without testing

Outdated statistics misleading optimizer

Missing indexes on join columns

Not filtering early enough

Assuming SQL order = execution order

Not using EXPLAIN to verify