쿼리 변환 - 테이블 EXPANSION

----- Current SQL Statement for this session (sql_id=91tcpq99r3wx5) -----
EXPLAIN PLAN FOR SELECT * FROM t WHERE n = 8
sql_text_length=45
sql=EXPLAIN PLAN FOR SELECT * FROM t WHERE n = 8
----- Explain Plan Dump -----
----- Plan Table -----

============
Plan Table
============
--------------------------------------------------------+-----------------------------------+---------------+
| Id  | Operation                             | Name    | Rows  | Bytes | Cost  | Time      | Pstart| Pstop |
--------------------------------------------------------+-----------------------------------+---------------+
| 0   | SELECT STATEMENT                      |         |       |       |   205 |           |       |       |
| 1   |  VIEW                                 | VW_TE_2 |    76 |  151K |   205 |  00:00:04 |       |       |
| 2   |   UNION-ALL                           |         |       |       |       |           |       |       |
| 3   |    PARTITION RANGE OR                 |         |    35 |  4130 |     1 |  00:00:01 | KEY(OR)| KEY(OR)|
| 4   |     TABLE ACCESS BY LOCAL INDEX ROWID | T       |    35 |  4130 |     1 |  00:00:01 | KEY(OR)| KEY(OR)|
| 5   |      INDEX RANGE SCAN                 | I       |    41 |       |     1 |  00:00:01 | KEY(OR)| KEY(OR)|
| 6   |    PARTITION RANGE ITERATOR           |         |    41 |  4838 |   204 |  00:00:04 | 2     | 3     |
| 7   |     TABLE ACCESS FULL                 | T       |    41 |  4838 |   204 |  00:00:04 | 2     | 3     |
--------------------------------------------------------+-----------------------------------+---------------+
Predicate Information:
----------------------
4 - filter(("T"."D"<TO_DATE(' 2012-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') OR ("T"."D">=TO_DATE(' 2012-10-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "T"."D"<TO_DATE(' 2013-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))))
5 - access("N"=8)
7 - filter("N"=8)

----- Current SQL Statement for this session (sql_id=91tcpq99r3wx5) -----
EXPLAIN PLAN FOR SELECT * FROM t WHERE n = 8
sql_text_length=45
sql=EXPLAIN PLAN FOR SELECT * FROM t WHERE n = 8
----- Explain Plan Dump -----
----- Plan Table -----

============
Plan Table
============
---------------------------------------+-----------------------------------+---------------+
| Id  | Operation            | Name    | Rows  | Bytes | Cost  | Time      | Pstart| Pstop |
---------------------------------------+-----------------------------------+---------------+
| 0   | SELECT STATEMENT     |         |       |       |     2 |           |       |       |
| 1   |  PARTITION RANGE ALL |         |     1 |  2037 |     2 |  00:00:01 | 1     | 4     |
| 2   |   TABLE ACCESS FULL  | T       |     1 |  2037 |     2 |  00:00:01 | 1     | 4     |
---------------------------------------+-----------------------------------+---------------+
Predicate Information:
----------------------
2 - filter("N"=8)