Session altered.


CUSTCD                    SEQ         ORDER_NO
------------------------- ----------- ----------
THEIR_REF
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    PERIOD USER_ID                   LAST_UPDA
---------- ------------------------- ---------
AB                                  0   98765432
XYZ123456
    201602 JOHNDOE                   21-SEP-15



PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  10n6d1qaca7ys, child number 0
-------------------------------------
select custcd,        SEQ,        ORDER_NO,        THEIR_REF,
     period,        user_id,        last_update   from table1
where custcd = 'AB'    and SEQ = 0    and THEIR_REF = 'XYZ123456'
   and period = 201602    and user_id = 'JOHNDOE'

Plan hash value: 1825820195

----------------------------------------------------------------------------------------------------------------
| Id  | Operation                           | Name           | Starts | E-Rows | A-Rows |   A-Time   | Buffers |
----------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                    |                |      1 |        |      1 |00:00:00.01 |     145 |
|*  1 |  TABLE ACCESS BY INDEX ROWID BATCHED| TABLE1         |      1 |      2 |      1 |00:00:00.01 |     145 |
|*  2 |   INDEX SKIP SCAN                   | TABLE1_IDX_7   |      1 |      7 |      6 |00:00:00.01 |     143 |
----------------------------------------------------------------------------------------------------------------

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
      DB_VERSION('12.1.0.2')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$1")
      INDEX_SS(@"SEL$1" "table1"@"SEL$1" ("table1"."custcd" "table1"."VOUCHER_TYPE"
              "table1"."THEIR_REF"))
      BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$1" "table1"@"SEL$1")
      END_OUTLINE_DATA
  */

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(("USER_ID"='JOHNDOE' AND "PERIOD"=201602 AND "SEQ"=0))
   2 - access("custcd"='AB' AND "THEIR_REF"='XYZ123456')
       filter("THEIR_REF"='XYZ123456')

Note
-----
   - dynamic statistics used: dynamic sampling (level=2)
   - 1 Sql Plan Directive used for this statement


45 rows selected.


Session altered.