Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=8070 Card=87749 Bytes=6844422)
1 0 HASH JOIN (Cost=8070 Card=87749 Bytes=6844422)
2 1 TABLE ACCESS (FULL) OF
'TB1' (Cost=2 Card=319 Bytes=4785)
3 1 TABLE ACCESS (BY INDEX ROWID) OF
'TB2' (Cost=8061,83547349652 Card=1 Bytes=31)
4 3 NESTED LOOPS (Cost=8061,83547349652 Card=87749 Bytes=5528187)
5 4 TABLE ACCESS (
FULL) OF
'TB3' (Cost=888 Card=701988 Bytes=22463616)
6 4 BITMAP CONVERSION (TO ROWIDS)
7 6 BITMAP AND
8 7 BITMAP CONVERSION (FROM ROWIDS)
9 8 INDEX (RANGE SCAN) OF 'TPK_TB2 (cle primaire de TB2) (UNIQUE)
10 7 BITMAP CONVERSION (FROM ROWIDS)
11 10 INDEX (RANGE SCAN) OF 'IDX1_MOUVEMENT' (NON-UNIQUE) (Cost=43 Card=8)
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
0 consistent gets
0 physical reads
0 redo size
0 bytes sent via SQL*Net to client
0 bytes received via SQL*Net from client
0 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
5 rows processed
Partager