2011-03-15Oracle EXPLAIN PLAN FOR
The method described in this section applies to the Oracle database Release 9iR2 and later.
Alternatively you can use the explain functionality of your favourite IDE. However, for several reasons I prefer not to cover all those IDEs here:
There are quite some different IDEs available that support explain plans, I can’t cover all of them.
There are some aspects—especially the predicate information—that is probably not available in all IDEs.
Since Oracle release 9iR2 there is a convenient way to format the execution plan that works in all environments.
There is, however, one nasty problem with that approach in connection to IDEs; if the IDE doesn’t use a monospaced font, the execution plan will not be formatted properly.
The execution plans shown in this book were formatted with the approach described in this section—so you don’t have different pictures.
share and subscribe
RSS FeedFlattr this! Follow me on TwitterShare at Google+Like on Facebook