---Autotrace for UNION Execution Plan ---------------------------------------------------------- Plan hash value: 3270510076 ---------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 5 | 100 | 6 (67)| 00:00:01 | | 1 | SORT UNIQUE | | 5 | 100 | 6 (67)| 00:00:01 | | 2 | UNION-ALL | | | | | | | 3 | TABLE ACCESS FULL| X | 2 | 40 | 2 (0)| 00:00:01 | | 4 | TABLE ACCESS FULL| Y | 3 | 60 | 2 (0)| 00:00:01 | ---------------------------------------------------------------------------- Note ----- - dynamic sampling used for this statement Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 6 consistent gets 0 physical reads 0 redo size 512 bytes sent via SQL*Net to client 384 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 2 rows processed -- Autotrace for UNIONALL Execution Plan ---------------------------------------------------------- Plan hash value: 1305462599 --------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 5 | 100 | 4 (50)| 00:00:01 | | 1 | UNION-ALL | | | | | | | 2 | TABLE ACCESS FULL| X | 2 | 40 | 2 (0)| 00:00:01 | | 3 | TABLE ACCESS FULL| Y | 3 | 60 | 2 (0)| 00:00:01 | --------------------------------------------------------------------------- Note ----- - dynamic sampling used for this statement Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 7 consistent gets 0 physical reads 0 redo size 527 bytes sent via SQL*Net to client 384 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 5 rows processed