As part of the #ThanksOTN idea on Twitter, my favourite Oracle feature is the ability to easily view and analyse execution plans for queries.

Time and time again I’ve needed to see how a query is running, and Oracle databases make it easy to view the execution plan.

You can view it in either a text format or a table format (at least in SQL Developer), and it’s even available with a keyboard shortcut.

It’s really helped me to make it easier improve my queries.

For the Oracle community’s favourite features, search for the #ThanksOTN tag on Twitter. I believe Tim from www.oracle-base.com is putting together a list.

Get Your SQL Function Cheat Sheet Now: