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

SAP Knowledge Base Article - Preview

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

Symptom

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 ); 


Read more...

Environment

[Env]

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

 2) IQ Version : IQ16 SP08 PL20

Product

SAP IQ 16.0

Keywords

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 page

This 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.