2108184 - [SAP IQ] How to enhance the performance of Query using "Not Exists".

When user executed a sql with not exists, It took a long time to be completed.

It took "5959.16 seconds" to be completed.

[SQL]

 SELECT COUNT(*) AS CNT      
     FROM TBIA70D AS C      
    WHERE C.B_ST_DT between '2010-04-01' and '2010-04-30'      
      AND C.SEG_GB_BIT LIKE '00%'      
      AND NOT EXISTS ( SELECT 'X' FROM ( SELECT A.MGT_ACCT_NO      
                       FROM TBIA59D A, TBIA70A B      
                      WHERE A.MGT_ACCT_NO = B.MGT_ACCT_NO      
                        AND A.B_ST_DT between '2010-04-01' and '2010-04-30'      
                        AND A.D0_REG_CD IN ('01','02')      
                                          ) AS B      
                          WHERE B.MGT_ACCT_NO = C.MGT_ACCT_NO ); 

[Env]

 1) Table Rows
     TBIA59D : 7,872,000
     TBIA70A : 10,541,000
     TBIA70D : 16,619,000

 2) IQ Version : IQ16 SP08 PL20

performance, Not Exists, Left Outer Join, index, HG, Index_Advisor, query, IQ, sybase, enhance , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem