What is query hinting in SQL?

Query hints force or guide the optimizer to use a specific execution plan.

Hints override optimizer decisions to enforce index usage, join order, or scan type. While useful for tuning, they can reduce portability and adaptability.