Oracle ACE Director, BI/data/all things cool and extraordinaire, Stewart Bryson had a bit of a complaint about our favorite tool today. He wants Explain Plans in SQL Developer to show the same notes you can see in SQL*Plus…
— Stewart Bryson (@stewartbryson) November 4, 2014
So how do you see the Explain Plan notes in SQL Developer?
The database writes that plan meta data to the plan table and its OTHER_XML column.
So in the preferences, if you turn that on…
Then you’ll see stuff like this when you use the Explain/Autotrace GUI tools in SQL Developer (vs running Explains manually in the worksheet a la SQL*Plus) :
Hard to see that?
I would say that I’m glad to make Stewart happy, but I’m guessing he’ll have some ideas on how to make this even better 🙂
P.S. I wrote this post on my Mac…
…and I just about got screen zooming and screenshots down using the native bits. But I must say, I really do miss having SnagIt on the Mac. So much nicer to do post-capture effects on my Windows setup.