Explain Plan

select distinct operation, options from  v$sql_plan order by operation;

 

   OPERATIONOPTIONS1BUFFERSORT2COLLECTION ITERATORPICKLER FETCH3CONCATENATION　4CONNECT BYNO FILTERING WITH START-WITH5CONNECT BYWITH FILTERING6CONNECT BY PUMP　7COUNTSTOPKEY8COUNT　9CREATE TABLE STATEMENT　10DDL STATEMENT　11DELETE　12DELETE STATEMENT　13FAST DUAL　14FILTER　15FIRST ROW　16FIXED TABLEFIXED INDEX17FIXED TABLEFULL18FOR UPDATE　19HASHGROUP BY20HASHUNIQUE21HASH JOINANTI22HASH JOINBUFFERED23HASH JOINOUTER24HASH JOINRIGHT OUTER25HASH JOINRIGHT SEMI26HASH JOINSEMI27HASH JOIN　28INDEXFAST FULL SCAN29INDEXFULL SCAN30INDEXFULL SCAN (MIN/MAX)31INDEXFULL SCAN DESCENDING32INDEXRANGE SCAN33INDEXRANGE SCAN (MIN/MAX)34INDEXRANGE SCAN DESCENDING35INDEXSAMPLE FAST FULL SCAN36INDEXSKIP SCAN37INDEXUNIQUE SCAN38INLIST ITERATOR　39INSERT STATEMENT　40LOAD AS SELECT　41MERGE　42MERGE JOINCARTESIAN43MERGE JOINOUTER44MERGE JOIN　45MERGE STATEMENT　46MINUS　47NESTED LOOPSANTI48NESTED LOOPSOUTER49NESTED LOOPS　50PARTITION LISTALL51PARTITION LISTSINGLE52PARTITION RANGEITERATOR53PARTITION RANGESINGLE54PX BLOCKITERATOR55PX COORDINATORFORCED SERIAL56PX COORDINATOR　57PX RECEIVE　58PX SENDHASH59PX SENDQC (ORDER)60PX SENDQC (RANDOM)61PX SENDRANGE62SELECT STATEMENT　63SEQUENCE　64SORTAGGREGATE65SORTGROUP BY66SORTGROUP BY NOSORT67SORTGROUP BY ROLLUP68SORTJOIN69SORTORDER BY70SORTORDER BY STOPKEY71SORTUNIQUE72SORTUNIQUE STOPKEY73TABLE ACCESSBY INDEX ROWID74TABLE ACCESSBY LOCAL INDEX ROWID75TABLE ACCESSBY USER ROWID76TABLE ACCESSCLUSTER77TABLE ACCESSFULL78TABLE ACCESSSAMPLE79TEMP TABLE TRANSFORMATION　80UNION-ALLPARTITION81UNION-ALL　82UPDATE　83UPDATE STATEMENT　84VIEW　85VIEW PUSHED PREDICATE　86WINDOWBUFFER87WINDOWSORT88WINDOWSORT PUSHED RANK