Explain Plan

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

 

	OPERATION	OPTIONS
1	BUFFER	SORT
2	COLLECTION ITERATOR	PICKLER FETCH
3	CONCATENATION
4	CONNECT BY	NO FILTERING WITH START-WITH
5	CONNECT BY	WITH FILTERING
6	CONNECT BY PUMP
7	COUNT	STOPKEY
8	COUNT
9	CREATE TABLE STATEMENT
10	DDL STATEMENT
11	DELETE
12	DELETE STATEMENT
13	FAST DUAL
14	FILTER
15	FIRST ROW
16	FIXED TABLE	FIXED INDEX
17	FIXED TABLE	FULL
18	FOR UPDATE
19	HASH	GROUP BY
20	HASH	UNIQUE
21	HASH JOIN	ANTI
22	HASH JOIN	BUFFERED
23	HASH JOIN	OUTER
24	HASH JOIN	RIGHT OUTER
25	HASH JOIN	RIGHT SEMI
26	HASH JOIN	SEMI
27	HASH JOIN
28	INDEX	FAST FULL SCAN
29	INDEX	FULL SCAN
30	INDEX	FULL SCAN (MIN/MAX)
31	INDEX	FULL SCAN DESCENDING
32	INDEX	RANGE SCAN
33	INDEX	RANGE SCAN (MIN/MAX)
34	INDEX	RANGE SCAN DESCENDING
35	INDEX	SAMPLE FAST FULL SCAN
36	INDEX	SKIP SCAN
37	INDEX	UNIQUE SCAN
38	INLIST ITERATOR
39	INSERT STATEMENT
40	LOAD AS SELECT
41	MERGE
42	MERGE JOIN	CARTESIAN
43	MERGE JOIN	OUTER
44	MERGE JOIN
45	MERGE STATEMENT
46	MINUS
47	NESTED LOOPS	ANTI
48	NESTED LOOPS	OUTER
49	NESTED LOOPS
50	PARTITION LIST	ALL
51	PARTITION LIST	SINGLE
52	PARTITION RANGE	ITERATOR
53	PARTITION RANGE	SINGLE
54	PX BLOCK	ITERATOR
55	PX COORDINATOR	FORCED SERIAL
56	PX COORDINATOR
57	PX RECEIVE
58	PX SEND	HASH
59	PX SEND	QC (ORDER)
60	PX SEND	QC (RANDOM)
61	PX SEND	RANGE
62	SELECT STATEMENT
63	SEQUENCE
64	SORT	AGGREGATE
65	SORT	GROUP BY
66	SORT	GROUP BY NOSORT
67	SORT	GROUP BY ROLLUP
68	SORT	JOIN
69	SORT	ORDER BY
70	SORT	ORDER BY STOPKEY
71	SORT	UNIQUE
72	SORT	UNIQUE STOPKEY
73	TABLE ACCESS	BY INDEX ROWID
74	TABLE ACCESS	BY LOCAL INDEX ROWID
75	TABLE ACCESS	BY USER ROWID
76	TABLE ACCESS	CLUSTER
77	TABLE ACCESS	FULL
78	TABLE ACCESS	SAMPLE
79	TEMP TABLE TRANSFORMATION
80	UNION-ALL	PARTITION
81	UNION-ALL
82	UPDATE
83	UPDATE STATEMENT
84	VIEW
85	VIEW PUSHED PREDICATE
86	WINDOW	BUFFER
87	WINDOW	SORT
88	WINDOW	SORT PUSHED RANK