Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Explain Plan

Re: Explain Plan

From: <amerar_at_iwc.net>
Date: 4 Feb 2005 06:06:58 -0800
Message-ID: <1107526018.174829.326000@z14g2000cwz.googlegroups.com>

Well, this was the output of running some PL/SQL procedure. There is nothing wrong with this query. What I am getting at, is how would one interpert all that?

I mean, I'd like to be able to figure out something like: First it did a full table scan using an index, then it did a sort on those records, next it joined with table B using columns C & D, then it did a full table scan without an index on table B.........

Knowing exactly what happened and in what order helps to understand the path that the query took. I have no clue by looking at this what happened first, and to what objects and what was done.........that is what I am trying to accomplish.

Arthur Received on Fri Feb 04 2005 - 08:06:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US