Plano de execução

[Marcio68AlmeidaParticipante]

Plano de Execução
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=RULE (Cost=10 Card=1 Bytes=139)
1 0 FILTER
2 1 MERGE JOIN (CARTESIAN) (Cost=7 Card=1 Bytes=139)
3 2 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'TB_EMPRESAS_NFS' (Cost=1 Card=1 Bytes=109)
4 3 NESTED LOOPS (Cost=2 Card=1 Bytes=126)
5 4 TABLE ACCESS (BY INDEX ROWID) OF 'TB_OBRAS' (Cost=1 Card=1 Bytes=17)
6 5 INDEX (RANGE SCAN) OF 'IDX_OBRAS_02' (NON-UNIQUE) (Cost=1 Card=1)
7 4 INDEX (RANGE SCAN) OF 'PK_EMPRESAS_NFS' (UNIQUE) (Cost=1 Card=1)
8 2 BUFFER (SORT) (Cost=6 Card=1 Bytes=13)
9 8 VIEW (Cost=5 Card=1 Bytes=13)
10 9 SORT (AGGREGATE)
11 10 FILTER
12 11 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'TB_EMPRESAS_NFS' (Cost=1 Card=1 Bytes=39)
13 12 NESTED LOOPS (Cost=2 Card=1 Bytes=54)
14 13 TABLE ACCESS (BY INDEX ROWID) OF 'TB_OBRAS' (Cost=1 Card=1 Bytes=15)
15 14 INDEX (RANGE SCAN) OF 'IDX_OBRAS_02' (NON-UNIQUE) (Cost=1 Card=1)
16 13 INDEX (RANGE SCAN) OF 'PK_EMPRESAS_NFS' (UNIQUE) (Cost=1 Card=1)
17 11 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'TB_EMPRESAS_NFS' (Cost=1 Card=1 Bytes=24)
18 17 INDEX (RANGE SCAN) OF 'IDX_TB_EMPRESAS_NFS_03' (NON-UNIQUE) (Cost=1 Card=1)
19 11 TABLE ACCESS (BY INDEX ROWID) OF 'TB_ENCERRAMENTOS' (Cost=2 Card=1 Bytes=22)
20 19 INDEX (RANGE SCAN) OF 'ENC_PK' (UNIQUE) (Cost=3 Card=1)
21 1 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'TB_EMPRESAS_NFS' (Cost=1 Card=1 Bytes=24)
22 21 INDEX (RANGE SCAN) OF 'IDX_TB_EMPRESAS_NFS_03' (NON-UNIQUE) (Cost=1 Card=1)
23 1 TABLE ACCESS (BY INDEX ROWID) OF 'TB_ENCERRAMENTOS' (Cost=2 Card=1 Bytes=22)
24 23 INDEX (RANGE SCAN) OF 'ENC_PK' (UNIQUE) (Cost=3 Card=1)


Estatística
----------------------------------------------------------
6623192 recursive calls
0 db block gets
9405916 consistent gets
158 physical reads
0 redo size
42983 bytes sent via SQL*Net to client
15458 bytes received via SQL*Net from client
29 SQL*Net roundtrips to/from client
159576 sorts (memory)
0 sorts (disk)
406 rows processed