Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 MERGE JOIN CARTESIAN (cr=16 pr=1 pw=0 time=13157 us cost=12 size=228 card=1)
1 1 1 HASH JOIN OUTER (cr=14 pr=1 pw=0 time=13068 us cost=11 size=215 card=1)
1 1 1 HASH JOIN (cr=12 pr=1 pw=0 time=12782 us cost=9 size=177 card=1)
1 1 1 NESTED LOOPS (cr=10 pr=1 pw=0 time=12407 us)
17 17 17 NESTED LOOPS (cr=9 pr=1 pw=0 time=12355 us cost=6 size=167 card=1)
1 1 1 NESTED LOOPS (cr=8 pr=0 pw=0 time=153 us cost=5 size=154 card=1)
1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=135 us cost=4 size=142 card=1)
1 1 1 NESTED LOOPS (cr=4 pr=0 pw=0 time=115 us cost=3 size=130 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=39 us cost=1 size=111 card=1)
1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=23 us cost=0 size=0 card=1)(object id 46)
1 1 1 TABLE ACCESS FULL USER_ASTATUS_MAP (cr=2 pr=0 pw=0 time=74 us cost=2 size=19 card=1)
1 1 1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 time=17 us cost=1 size=12 card=1)
1 1 1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 7)
1 1 1 TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 time=14 us cost=1 size=12 card=1)
1 1 1 INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 time=2 us cost=0 size=0 card=1)(object id 7)
17 17 17 INDEX RANGE SCAN I_PROFILE (cr=1 pr=1 pw=0 time=12206 us cost=0 size=0 card=17)(object id 285)
1 1 1 TABLE ACCESS BY INDEX ROWID PROFILE$ (cr=1 pr=0 pw=0 time=43 us cost=1 size=13 card=1)
2 2 2 TABLE ACCESS FULL PROFNAME$ (cr=2 pr=0 pw=0 time=46 us cost=2 size=10 card=1)
0 0 0 TABLE ACCESS FULL RESOURCE_GROUP_MAPPING$ (cr=2 pr=0 pw=0 time=46 us cost=2 size=38 card=1)
1 1 1 BUFFER SORT (cr=2 pr=0 pw=0 time=80 us cost=10 size=13 card=1)
1 1 1 TABLE ACCESS BY INDEX ROWID PROFILE$ (cr=2 pr=0 pw=0 time=42 us cost=1 size=13 card=1)
17 17 17 INDEX RANGE SCAN I_PROFILE (cr=1 pr=0 pw=0 time=35 us cost=0 size=0 card=17)(object id 285)