Forum Stats

  • 3,727,603 Users
  • 2,245,418 Discussions
  • 7,852,886 Comments

Discussions

Feature Request: Explain Plan

Ray007
Ray007 Member Posts: 28 Bronze Badge

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

  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 1,852 Employee

    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

Sign In or Register to comment.