When user executed a sql with not exists, It took a long time to be completed.
It took "5959.16 seconds" to be completed.
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 );
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
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.