Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Want to know the meaning of the KeyWords used in the execution plan
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