Where I find plan hints very helpful is to force query a certain way of query execution to validate if the plan you THINK is better actually better. In many ca

Where I find plan hints very helpful is to force query a certain way of query execution to validate if the plan you THINK is better actually better. In many cases I see developers thinking they have better plan in mind... only to see it actually results in slower query execution. It is easy to demo for MySQL but not so for PostgreSQL