Use optimizer hints as a last resort when you need to guide the query optimizer towards a specific execution plan.