Forum Stats

  • 3,769,008 Users
  • 2,252,898 Discussions
  • 7,874,840 Comments

Discussions

Feature Request: Explain Plan

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?

Answers

  • 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