3 ms·

Never use hints in production!

• brianwawok 11y ago
  Client or server side? (I guess maybe the oracle side "hints" have another name, but my Oracle-Foo is not strong enough to remember the name query plan?). I have seen some really big shops that the only way they could keep their app running in production was a fair bit of server side hints. Which then really sucked because someone fixed the casing on a table name (say "Orders" to "orders") and made it fall out of the query plan. Whereas if they were done as hints, they would have kept working.
  • jerven 11y ago
    The new query plan stabilization features in 12cEE really help with this. Hints are a pain when upgrading Oracle major versions as they can affect query correctness, as my boss found out painfully last week ;(
    • AlisdairO 11y ago
      I too think plan stabilisation is the important thing. What people particularly want is the ability to know that their production performance is not just going to suddenly crash and burn because of a change in plan.