3 ms·
Several of these are "features" exist to fix broken parts of Oracle (like query/planner hints, planner adjustment, etc). Officially (per Oracle) the planner sho
by Someone1234 6y ago
Several of these are "features" exist to fix broken parts of Oracle (like query/planner hints, planner adjustment, etc). Officially (per Oracle) the planner should be good enough so you never need to use a hint, but realistically all of these are "features" because the built-in systems aren't good.
So, granted, other databases don't have Oracle's hacks to fix their broken stuff but I'm not sure why that is an argument FOR using Oracle rather than AGAINST. Hints are fragile hacks.
- vbezhenar 6y agoSo what do you do when you encounter bug in Postgres planner? File a bug and wait for months or years until fix is released? Hack postgres source and fork it? Using hints sounds like a more sane solution. Nobody's perfect. Being able to work around is better than not being able to.