3 ms·

Poster said oracle not PG

• mardifoufs 3y ago
  Total db noob here: is Oracle's query planner better? What's the difference between the two?
  • _a_a_a_ 3y ago
    This is not about Oracle versus postgres, it's about whether or not to use hints. My position is that needing hints indicates a failure of the database optimiser. The optimiser theoretically should do a perfect job. In practice it doesn't, and never can so sometimes hints are necessary, but IME and speaking as an MSSQL guy, I very rarely need them.
• mickeyp 3y ago
  Oracle has query hints; pg does not. Query planner hinters are useful. That's my point.