I’ve written several notes about hinting, such as:
- Hints again: do you know what they really mean.
- Ignoring hints: new DDL makes old hints “ignorable”.
- Full Hinting: the difficulty of getting it right.
- qb_name: a really important hint introduced in 10g
- push_subq: how upgrades can stop hints working.
