Feature Request: Explain Plan

Ray007

It would be nice if I could put a query in and explain the plan for it.

My current work-around is to run this:

explain plan for

select something super special

from lots_of_tables

where something is awesome;

select * from table(dbms_xplan.display);

The problem is that the display is hard to read. Is there a way to set this to used a fixed width font in the results?

Christian.Shay -Oracle

Hi Ray,

Sorry that the explain plan looks so bad in the output.

When the select output doesn't look good with our extension, the workaround I have been using is the SPOOL command. I find that the file output tends to be easier to read in some cases.

Can you please try adding:

spool c:\myfolder\myspoolfile.txt