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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.