CREATE UNIQUE INDEX BAANDB.TTFGLD469106$IDX1 ON BAANDB.TTFGLD469106
(NLSSORT("T$MSCD",'nls_sort=''UCA0610_DUCET_S3_VN_BN_NY_EN_FN_HN_DN_MN'''), T$MSVS, NLSSORT("T$EGCD",'nls_sort=''UCA0610_DUCET_S3_VN_BN_NY_EN_FN_HN_DN_MN'''), T$TCMP, T$FCMP, 
T$PRIO, T$SEQN)
LOGGING
TABLESPACE BAANDB_AUTO_IDX

SELECT /*+ FIRST_ROWS(5) */ a0.t$tcmp,a0.t$fcmp,a0.t$prio,a0.t$seqn 
FROM baandb.ttfgld469106 a0 ,baandb.ttfgld469106 a1  
WHERE NOT EXISTS (
SELECT 0 
FROM baandb.ttfgld469106 a2  
WHERE a2.t$mscd = :1 AND a2.t$msvs = :2 AND a2.t$egcd = :3 AND a2.t$tcmp = a1.t$tcmp AND a2.t$fcmp = a1.t$fcmp 
  AND a2.t$prio = a0.t$prio AND a2.t$seqn = a0.t$seqn) AND a1.t$fcmp = a0.t$fcmp AND a1.t$tcmp = a0.t$tcmp AND a1.t$mscd = :4 
  AND a1.t$msvs = :5 AND a1.t$egcd = :6 AND a0.t$mscd = :7 AND a0.t$msvs = :8 AND a0.t$egcd = :9 ORDER BY 1,2,3,4;

  --------------------------------------------------------------------------------------
| Id  | Operation             | Name         | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |              |  2417 |   306K|   177K  (1)| 00:00:07 |
|   1 |  SORT ORDER BY        |              |  2417 |   306K|   177K  (1)| 00:00:07 |
|*  2 |   HASH JOIN RIGHT ANTI|              |  2417 |   306K|   177K  (1)| 00:00:07 |
|*  3 |    TABLE ACCESS FULL  | TTFGLD469106 |   527 | 24242 | 59321   (1)| 00:00:03 |
|*  4 |    HASH JOIN          |              |   241K|    19M|   118K  (1)| 00:00:05 |
|*  5 |     TABLE ACCESS FULL | TTFGLD469106 |   527 | 24242 | 59321   (1)| 00:00:03 |
|*  6 |     TABLE ACCESS FULL | TTFGLD469106 |   527 | 20026 | 59321   (1)| 00:00:03 |
--------------------------------------------------------------------------------------

SELECT /*+ index(a0 TTFGLD469106$IDX1) index(a1 TTFGLD469106$IDX1) */ a0.t$tcmp,a0.t$fcmp,a0.t$prio,a0.t$seqn 
FROM baandb.ttfgld469106 a0 ,baandb.ttfgld469106 a1  
WHERE NOT EXISTS (
SELECT 0 
FROM baandb.ttfgld469106 a2  
WHERE a2.t$mscd = :1 AND a2.t$msvs = :2 AND a2.t$egcd = :3 AND a2.t$tcmp = a1.t$tcmp AND a2.t$fcmp = a1.t$fcmp 
  AND a2.t$prio = a0.t$prio AND a2.t$seqn = a0.t$seqn) AND a1.t$fcmp = a0.t$fcmp AND a1.t$tcmp = a0.t$tcmp AND a1.t$mscd = :4 
  AND a1.t$msvs = :5 AND a1.t$egcd = :6 AND a0.t$mscd = :7 AND a0.t$msvs = :8 AND a0.t$egcd = :9 ORDER BY 1,2,3,4;

----------------------------------------------------------------------------------------------------
| Id  | Operation                              | Name              | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                       |                   |  2417 |   306K| 59619   (1)| 00:00:03 |
|   1 |  SORT ORDER BY                         |                   |  2417 |   306K| 59619   (1)| 00:00:03 |
|*  2 |   HASH JOIN RIGHT ANTI                 |                   |  2417 |   306K| 59618   (1)| 00:00:03 |
|*  3 |    TABLE ACCESS FULL                   | TTFGLD469106      |   527 | 24242 | 59321   (1)| 00:00:03 |
|*  4 |    HASH JOIN                           |                   |   241K|    19M|   293   (2)| 00:00:01 |
|*  5 |     TABLE ACCESS BY INDEX ROWID BATCHED| TTFGLD469106      |   527 | 24242 |   145   (1)| 00:0
|*  6 |      INDEX FULL SCAN                   | TTFGLD469106$IDX1 | 32702 |       |   124   (1)| 00:00:01 |
|*  7 |     TABLE ACCESS BY INDEX ROWID BATCHED| TTFGLD469106      |   527 | 20026 |   145   (1)| 00:0
|*  8 |      INDEX FULL SCAN                   | TTFGLD469106$IDX1 | 32702 |       |   124   (1)| 00:00:01 |
----------------------------------------------------------------------------------------------------