Hacker News new | ask | show | jobs
by venkat971 40 days ago
Hints are great way to experiment, but should not live in live production queries. From my Oracle database days, we saw many customer workloads where old hints overrode the latest database optimizations. Believe in the optimizer's own decisions on plan execution trees, you will have peace of mind.