"PLAN_TABLE_OUTPUT"
"Plan hash value: 3718829819"
" "
"-----------------------------------------------------------------------------------------------------------------"
"| Id  | Operation                            | Name                     | Rows  | Bytes | Cost (%CPU)| Time     |"
"-----------------------------------------------------------------------------------------------------------------"
"|   0 | SELECT STATEMENT                     |                          |   223 | 31443 |  2121   (2)| 00:00:26 |"
"|   1 |  COUNT                               |                          |       |       |            |          |"
"|   2 |   NESTED LOOPS OUTER                 |                          |   223 | 31443 |  2121   (2)| 00:00:26 |"
"|   3 |    NESTED LOOPS OUTER                |                          |   223 | 31443 |  2071   (3)| 00:00:25 |"
"|   4 |     NESTED LOOPS OUTER               |                          |   223 | 31443 |  2021   (3)| 00:00:25 |"
"|   5 |      NESTED LOOPS OUTER              |                          |   223 | 17840 |  2017   (3)| 00:00:25 |"
"|   6 |       NESTED LOOPS OUTER             |                          |   223 | 12042 |  2016   (3)| 00:00:25 |"
"|   7 |        NESTED LOOPS SEMI             |                          |   223 | 11373 |  2016   (3)| 00:00:25 |"
"|   8 |         NESTED LOOPS                 |                          |   425 | 18275 |  1165   (4)| 00:00:14 |"
"|   9 |          INLIST ITERATOR             |                          |       |       |            |          |"
"|* 10 |           TABLE ACCESS BY INDEX ROWID| MKT_RISK_VAR             |   425 | 14875 |  1165   (4)| 00:00:14 |"
"|* 11 |            INDEX RANGE SCAN          | MKT_RISK_VAR_AGG_BUS     |   899 |       |  1147   (4)| 00:00:14 |"
"|* 12 |          INDEX UNIQUE SCAN           | DATE_DIM_UK              |     1 |     8 |     0   (0)| 00:00:01 |"
"|* 13 |         INDEX RANGE SCAN             | DATA_KEY_BUS_PRIMARY     |    11M|    88M|     2   (0)| 00:00:01 |"
"|* 14 |        INDEX UNIQUE SCAN             | MKT_RISK_AGGR_TYPES_IDX1 |     1 |     3 |     0   (0)| 00:00:01 |"
"|  15 |       TABLE ACCESS BY INDEX ROWID    | MKT_RISK_HEIRARCHY       |     1 |    26 |     1   (0)| 00:00:01 |"
"|* 16 |        INDEX RANGE SCAN              | HEIRARCHY_PK             |     1 |       |     0   (0)| 00:00:01 |"
"|  17 |      TABLE ACCESS BY INDEX ROWID     | ENTITY                   |     1 |    61 |     1   (0)| 00:00:01 |"
"|* 18 |       INDEX UNIQUE SCAN              | ENTITY_NAME_TYPE_KEY     |     1 |       |     0   (0)| 00:00:01 |"
"|  19 |     VIEW                             |                          |     1 |       |     0   (0)| 00:00:01 |"
"|* 20 |      FILTER                          |                          |       |       |            |          |"
"|  21 |       NESTED LOOPS OUTER             |                          |  8562 |   267K|  1240   (1)| 00:00:15 |"
"|  22 |        NESTED LOOPS OUTER            |                          |  8562 |   242K|  1239   (1)| 00:00:15 |"
"|  23 |         TABLE ACCESS BY INDEX ROWID  | MKT_RISK_VAR             |  8562 |   192K|  1237   (1)| 00:00:15 |"
"|* 24 |          INDEX RANGE SCAN            | MKT_RISK_VAR_IDX_01      |  8562 |       |   372   (1)| 00:00:05 |"
"|* 25 |         INDEX RANGE SCAN             | HEIRARCHY_PK             |     1 |     6 |     0   (0)| 00:00:01 |"
"|* 26 |        INDEX UNIQUE SCAN             | MKT_RISK_AGGR_TYPES_IDX1 |     1 |     3 |     0   (0)| 00:00:01 |"
"|  27 |    VIEW                              |                          |     1 |       |     0   (0)| 00:00:01 |"
"|* 28 |     FILTER                           |                          |       |       |            |          |"
"|  29 |      NESTED LOOPS OUTER              |                          |  8806 |   275K|  1276   (1)| 00:00:16 |"
"|  30 |       NESTED LOOPS OUTER             |                          |  8806 |   249K|  1275   (1)| 00:00:16 |"
"|  31 |        TABLE ACCESS BY INDEX ROWID   | MKT_RISK_VAR             |  8806 |   197K|  1273   (1)| 00:00:16 |"
"|* 32 |         INDEX RANGE SCAN             | MKT_RISK_VAR_IDX_01      |  8806 |       |   384   (2)| 00:00:05 |"
"|* 33 |        INDEX RANGE SCAN              | HEIRARCHY_PK             |     1 |     6 |     0   (0)| 00:00:01 |"
"|* 34 |       INDEX UNIQUE SCAN              | MKT_RISK_AGGR_TYPES_IDX1 |     1 |     3 |     0   (0)| 00:00:01 |"
"-----------------------------------------------------------------------------------------------------------------"
" "
"Predicate Information (identified by operation id):"
"---------------------------------------------------"
" "
"  10 - filter(""M"".""PROCESSING_STATUS_KEY""<>5)"
"  11 - access(""M"".""AGGREGATION_KEY""=3 OR ""M"".""AGGREGATION_KEY""=4)"
"       filter(""M"".""BUSINESS_DATE"">=INTERNAL_FUNCTION(""M"".""BUSINESS_DATE"")-1 AND "
"              ""M"".""BUSINESS_DATE""<=INTERNAL_FUNCTION(""M"".""BUSINESS_DATE"")+1)"
"  12 - access(""M"".""BUSINESS_DATE""=""LONG_DATE"")"
"  13 - access(""BUSINESS_DATE""=""A"".""LONG_DATE"")"
"  14 - access(""M"".""AGGREGATION_KEY""=""A"".""AGGREGATION_KEY""(+))"
"  16 - access(""M"".""HEIRARCHY_KEY""=""H"".""HEIRARCHY_KEY""(+))"
"  18 - access(""H"".""ACCOUNT""=""EN"".""ENTITY_NAME""(+) AND ""EN"".""ENTITY_TYPE""(+)='account')"
"  20 - filter(""M"".""PREV_BUS_DATE"" IS NOT NULL)"
"  24 - access(""M"".""PREV_BUS_DATE""=""M"".""BUSINESS_DATE"" AND ""M"".""AGGREGATION_KEY""=""M"".""AGGREGATION_KEY"" "
"              AND ""M"".""AGGREGATION_LEVEL""=""M"".""AGGREGATION_LEVEL"")"
"       filter(""M"".""AGGREGATION_LEVEL""=""M"".""AGGREGATION_LEVEL"" AND ""M"".""PROCESSING_STATUS_KEY""<>5 AND "
"              ""M"".""AGGREGATION_KEY""=""M"".""AGGREGATION_KEY"")"
"  25 - access(""M"".""HEIRARCHY_KEY""=""H"".""HEIRARCHY_KEY""(+))"
"  26 - access(""M"".""AGGREGATION_KEY""=""A"".""AGGREGATION_KEY""(+))"
"  28 - filter(""M"".""PREV5_BUS_DATE"" IS NOT NULL)"
"  32 - access(""M"".""PREV5_BUS_DATE""=""M"".""BUSINESS_DATE"" AND ""M"".""AGGREGATION_KEY""=""M"".""AGGREGATION_KEY"" "
"              AND ""M"".""AGGREGATION_LEVEL""=""M"".""AGGREGATION_LEVEL"")"
"       filter(""M"".""AGGREGATION_LEVEL""=""M"".""AGGREGATION_LEVEL"" AND ""M"".""PROCESSING_STATUS_KEY""<>5 AND "
"              ""M"".""AGGREGATION_KEY""=""M"".""AGGREGATION_KEY"")"
"  33 - access(""M"".""HEIRARCHY_KEY""=""H"".""HEIRARCHY_KEY""(+))"
"  34 - access(""M"".""AGGREGATION_KEY""=""A"".""AGGREGATION_KEY""(+))"