PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Plan hash value: 2038791377 ------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 21M| 4334M| | 1509K (1)| 05:01:53 | | | |* 1 | HASH JOIN RIGHT ANTI | | 21M| 4334M| 5352K| 1509K (1)| 05:01:53 | | | | 2 | TABLE ACCESS BY INDEX ROWID| SYS_LOG | 195K| 3056K| | 2696 (1)| 00:00:33 | | | |* 3 | INDEX RANGE SCAN | I_PRG_ATTIVITA_SYS_LOG | 195K| | | 652 (1)| 00:00:08 | | | | 4 | PARTITION RANGE ALL | | 21M| 4002M| | 1295K (1)| 04:19:04 | 1 | 25 | |* 5 | TABLE ACCESS FULL | SPS_UNI_A1_IMPORT | 21M| 4002M| | 1295K (1)| 04:19:04 | 1 | 25 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("L"."PRG_FILE"="A"."PRG_FILE" AND "A"."PRG_REC"="L"."PRG_REC") 3 - access("L"."PRG_ATTIVITA"=474) 5 - filter("A"."ANNO"=2010) SQL> spool off