‘All explain planners occasionally lie, some lie more often than others’ – Jonathon Lewis (allegedly).
Toad explain plan (the ambulance icon) lies more than ‘explain plan for …’ / ‘Select * from table(dbms_xplan.display)’.
Toad explain plan caught me out more than once.
No comments:
Post a Comment