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

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.