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

Home -> Community -> Usenet -> c.d.o.server -> Re: Want to know the meaning of the KeyWords used in the execution plan

Re: Want to know the meaning of the KeyWords used in the execution plan

From: Balaji Natarajan <balaji.natarajan_at_oracle.com>
Date: Fri, 09 Sep 2005 17:48:29 +0530
Message-ID: <FkfUe.23$_21.120@news.oracle.com>


Thanks....Michel...The Link helped a lot !!

Michel Cadot wrote:
> <juhunu_at_gmail.com> a écrit dans le message de news: 1126257369.394856.134350_at_z14g2000cwz.googlegroups.com...
> |I want to know that actual meaning of some of the keywords used in the
> | Oracle SQL query execution plan.
> |
> | Some of these are
> |
> | INDEX UNIQUE SCAN
> | INDEX RANGE SCAN
> | NESTED LOOPS
> | SORT ORDER BY
> | SORT UNIQUE
> | FILTER
> | INLIST ITERATOR
> | HASH JOIN
> |
> | It would be much helpful to me, if i am pointed to some of the right
> | places where I can get all the things needed to interpret these kewords
> | used in the plan.
> |
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/ex_plan.htm#17522
>
> Regards
> Michel Cadot
>
>
Received on Fri Sep 09 2005 - 07:18:29 CDT

Original text of this message

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