plain.txt

Plan hash value: 1691833290
 
-------------------------------------------------------------------------------------------------
| Id  | Operation                     | Name            | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT              |                 |     7 |  1085 |     6  (34)| 00:00:01 |
|   1 |  HASH UNIQUE                  |                 |     7 |  1085 |     6  (34)| 00:00:01 |
|   2 |   NESTED LOOPS                |                 |       |       |            |          |
|   3 |    NESTED LOOPS               |                 |     7 |  1085 |     5  (20)| 00:00:01 |
|   4 |     VIEW                      | VW_DTP_BA8ECEFB |     7 |    91 |     4  (25)| 00:00:01 |
|   5 |      HASH UNIQUE              |                 |     7 |   182 |     4  (25)| 00:00:01 |
|*  6 |       TABLE ACCESS FULL       | GAME            |     7 |   182 |     3   (0)| 00:00:01 |
|*  7 |     INDEX UNIQUE SCAN         | SYS_C00281772   |     1 |       |     0   (0)| 00:00:01 |
|   8 |    TABLE ACCESS BY INDEX ROWID| PLAYER          |     1 |   142 |     1   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   6 - filter("T1"."START_DATE"<=TO_TIMESTAMP('31.12.2017 00:00:00,0') AND 
              "T1"."START_DATE">=TO_TIMESTAMP('01.01.2017 00:00:00,0'))
   7 - access("T0"."ID"="ITEM_1")
 
Note
-----
   - dynamic sampling used for this statement (level=2)