As much as I like the traditional explain plan support in SQL Developer, and even the ability to pull cached plans out by the SQL_ID – sometimes you just want to get the plan the old fashioned way.

The New Way

Note the drop-down control added to the Explain Plan button in the worksheet toolbar.
Note the drop-down control added to the Explain Plan button in the worksheet toolbar.

The Older Way

Ask for plan, show plan.
Ask for plan, show plan.

Ugh. That’s a little icky to read.

Remember – you need to set a fixed-width font.

Tools – Preferences – Code Editor – Fonts

Ahhh, that's much better :)
Ahhh, that’s much better 🙂

Fonts Are Very Important

If you’re having display issues with your data, it’s almost ALWAYS the font’s fault. Set a font that supports the characters and character sets you’re trying to display. You don’t have to worry much about corruption with SQL Developer because we natively support Unicode.

A Font that's not non-English friendly
A Font that’s not non-English friendly

Exact same text, except rendered with the Tahoma font
Exact same text, except rendered with the Tahoma font
thatjeffsmith
Author

I'm a Senior Principal Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

Write A Comment