PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 1895877274

-------------------------------------------------------------------------------------------------------------
| Id  | Operation                        | Name                     | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                 |                          |    69 |  3588 |    91G  (1)|999:59:59 |
|   1 |  SORT GROUP BY                   |                          |    69 |  3588 |    91G  (1)|999:59:59 |
|*  2 |   FILTER                         |                          |       |       |            |          |
|   3 |    NESTED LOOPS                  |                          |   476K|    23M|  7249   (1)| 00:01:27 |
|   4 |     NESTED LOOPS                 |                          |   474K|    19M|  7245   (1)| 00:01:27 |
|   5 |      SORT UNIQUE                 |                          |   296K|  1446K|   161   (1)| 00:00:02 |
|   6 |       INDEX FULL SCAN            | IDX_IMT_ACCT_ID          |   296K|  1446K|   161   (1)| 00:00:02 |
|   7 |      INLIST ITERATOR             |                          |       |       |            |          |
|*  8 |       TABLE ACCESS BY INDEX ROWID| GENERAL_ACCT_MAST_TABLE  |  6882 |   248K|    89   (0)| 00:00:02 |
|*  9 |        INDEX RANGE SCAN          | IDX_GAM_SCHM_TYPE_SOL_ID |  5076 |       |     1   (0)| 00:00:01 |
|* 10 |     INDEX UNIQUE SCAN            | IDX_SBCA_MAST_TABLE      |     1 |    10 |     1   (0)| 00:00:01 |
|* 11 |    TABLE ACCESS FULL             | IMAGE_TABLE              |     1 |    10 |   195K  (1)| 00:39:03 |
-------------------------------------------------------------------------------------------------------------

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

   2 - filter( NOT EXISTS (SELECT /*+ */ 0 FROM "TBAADM"."IMAGE_TABLE" "IMT" WHERE
              LNNVL("ACID"<>:B1)))
   8 - filter("GAM"."ACCT_CLS_FLG"='N')
   9 - access(("GAM"."SCHM_TYPE"='CAA' OR "GAM"."SCHM_TYPE"='CCA' OR "GAM"."SCHM_TYPE"='ODA' OR
              "GAM"."SCHM_TYPE"='SBA') AND "GAM"."SOL_ID"="SOL_ID")
  10 - access("GAM"."ACID"="SMT"."ACID")
  11 - filter(LNNVL("ACID"<>:B1))

29 rows selected.