SAP Knowledge Base Article - Preview

2899060 - A query -- nothing 'From Clause' , kind of CIS operation-- returns long performance. - SAP IQ

Symptom

Following Query pattern -- nothing From clause -- returned long performance delay. 
( 'Where clause' in this query has nothing to do with this performance issue at all )

INSERT into Test_TB (COL1, TradeDate, COL3, Version, COL4, COL5, COL6, COL7, COL8, COL9,COL10,COL11, COL12, COL13)
SELECT 'ABC','20200228','B020',10,'ABC','AUD','ALL','F','33','D','R','A',96000,''
WHERE not exists (SELECT 1 FROM Test_TB WHERE COL1 = 'ABC'
     and TradeDate = '20200228' and COL3 = 'B020'
     and Version = 10 and COL4 = 'ABC' and COL5 = 'AUD' ) ;

But below similar query pattern returned expected performance,


SELECT 'ABC','20200228','B020',10,'ABC','AUD','ALL','F','33','D','R','A',96000,''
WHERE not exists (SELECT 1 FROM Test_TB WHERE COL1 = 'ABC'
and TradeDate = '20200228' and COL3 = 'B020'
and Version = 10 and COL4 = 'ABC' and COL5 = 'AUD' );

,or,

INSERT into Test_TB (COL1, TradeDate, COL3, Version, COL4, COL5, COL6, COL7, COL8,
COL9,COL10,COL11, COL12, COL13)
SELECT 'ABC','20200228','B020',10,'ABC','AUD','ALL','F','33','D','R','A',96000,''


Read more...

Environment

SAP IQ16.1

Product

SAP IQ 16.1

Keywords

CIS, Pass through, SA operation, SA Table, From Clause, , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

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