Id 	Operation 	Name 	Rows 	Bytes 	TempSpc	Cost (%CPU)	Time 	Pstart	Pstop 	TQ 	IN-OUT	PQ Distrib
0 	SELECT STATEMENT 	 	 	 	 	2152 (100)	 	 	 	 	 	 
1 	   SORT AGGREGATE 	 	1 	94 	 	 	 	 	 	 	 	 
2 	     PX COORDINATOR 	 	 	 	 	 	 	 	 	 	 	 
3 	       PX SEND QC (RANDOM) 	:TQ10002 	1 	94 	 	 	 	 	 	Q1,02 	P->S 	QC (RAND)
4 	         SORT AGGREGATE 	 	1 	94 	 	 	 	 	 	Q1,02 	PCWP 	 
5 	           HASH JOIN RIGHT OUTER 	 	17M	1582M	 	2152 (3)	00:00:26 	 	 	Q1,02 	PCWP 	 
6 	             BUFFER SORT 	 	 	 	 	 	 	 	 	Q1,02 	PCWC 	 
7 	               PX RECEIVE 	 	194K	4946K	 	1216 (3)	00:00:15 	 	 	Q1,02 	PCWP 	 
8 	                 PX SEND BROADCAST 	:TQ10000 	194K	4946K	 	1216 (3)	00:00:15 	 	 	 	S->P 	BROADCAST
9 	                   VIEW 	 	194K	4946K	 	1216 (3)	00:00:15 	 	 	 	 	 
10 	                     HASH JOIN 	 	194K	10M	7080K	1216 (3)	00:00:15 	 	 	 	 	 
11 	                       INDEX FAST FULL SCAN 	XPKCLAIM_REASSIGN 	219K	4501K	 	158 (4)	00:00:02 	 	 	 	 	 
12 	                       VIEW 	VW_SQ_1 	194K	6659K	 	267 (4)	00:00:04 	 	 	 	 	 
13 	                         HASH GROUP BY 	 	194K	6468K	17M	267 (4)	00:00:04 	 	 	 	 	 
14 	                           INDEX FULL SCAN 	XPKCLAIM_REASSIGN 	219K	7288K	 	267 (4)	00:00:04 	 	 	 	 	 
15 	             TABLE ACCESS BY GLOBAL INDEX ROWID	CLAIM_VERSION 	205 	9020 	 	2 (0)	00:00:01 	ROW L 	ROW L 	Q1,02 	PCWP 	 
16 	               NESTED LOOPS 	 	17M	1145M	 	915 (1)	00:00:11 	 	 	Q1,02 	PCWP 	 
17 	                 BUFFER SORT 	 	 	 	 	 	 	 	 	Q1,02 	PCWC 	 
18 	                   PX RECEIVE 	 	 	 	 	 	 	 	 	Q1,02 	PCWP 	 
19 	                     PX SEND ROUND-ROBIN 	:TQ10001 	 	 	 	 	 	 	 	 	S->P 	RND-ROBIN
20 	                       INDEX RANGE SCAN 	XPKDATA_SCOPE 	1756 	42144 	 	6 (0)	00:00:01 	 	 	 	 	 
21 	                 INDEX RANGE SCAN 	CLAIM_VERSION_SA_BU_PS_ACI_IDX 	721 	 	 	0 (0)	 	 	 	Q1,02 	PCWP