Execution Plan
0 SELECT STATEMENT Optimizer=HINT: RULE (Cost=1522 Card=1 Byte
s=26)
1 0 NESTED LOOPS (Cost=1522 Card=1 Bytes=26)
2 1 VIEW (Cost=1435 Card=1 Bytes=13)
3 2 SORT (AGGREGATE)
4 3 VIEW (Cost=1435 Card=1 Bytes=19)
5 4 SORT (GROUP BY) (Cost=1435 Card=1 Bytes=182)
6 5 NESTED LOOPS (Cost=1429 Card=1 Bytes=182)
7 6 NESTED LOOPS (Cost=1429 Card=1 Bytes=156)
8 7 HASH JOIN (Cost=35 Card=82 Bytes=6396)
9 8 TABLE ACCESS (FULL) OF 'UNDO$' (Cost=17 Ca
rd=82 Bytes=4264)
10 8 TABLE ACCESS (FULL) OF 'TS$' (Cost=17 Card
=8168 Bytes=212368)
11 7 FIXED TABLE (FIXED INDEX) OF 'X$KTFBUE (ind:
1)' (Cost=17 Card=1 Bytes=78)
12 6 INDEX (UNIQUE SCAN) OF 'I_FILE2' (UNIQUE)
13 1 VIEW (Cost=87 Card=1 Bytes=13)
14 13 SORT (AGGREGATE)
15 14 NESTED LOOPS (Cost=87 Card=1 Bytes=810)
16 15 NESTED LOOPS (Cost=70 Card=1 Bytes=513)
17 16 NESTED LOOPS (Cost=53 Card=1 Bytes=487)
18 17 HASH JOIN (Cost=36 Card=1 Bytes=190)
19 18 NESTED LOOPS (Cost=18 Card=1 Bytes=99)
20 19 FIXED TABLE (FULL) OF 'X$KCCTS' (Cost=17 C
ard=1 Bytes=43)
21 19 TABLE ACCESS (BY INDEX ROWID) OF 'TS$' (Co
st=1 Card=1 Bytes=56)
22 21 INDEX (UNIQUE SCAN) OF 'I_TS1' (UNIQUE)
23 18 FIXED TABLE (FULL) OF 'X$KCCFE' (Cost=17 Car
d=1 Bytes=91)
24 17 FIXED TABLE (FIXED INDEX) OF 'X$KCCFN (ind:1)'
(Cost=17 Card=1 Bytes=297)
25 16 FIXED TABLE (FIXED INDEX) OF 'X$KCVFH (ind:1)' (
Cost=17 Card=1 Bytes=26)
26 15 FIXED TABLE (FULL) OF 'X$KCCFN' (Cost=17 Card=1 By
tes=297)
Statistics
1356 recursive calls
0 db block gets
322 consistent gets
46 physical reads
0 redo size
429 bytes sent via SQL*Net to client
456 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
0 rows processed
Received on Wed Jan 11 2006 - 11:01:49 CST
