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

<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 - 04:36:48 CDT