SAP Knowledge Base Article - Preview

2756568 - IQ 16.1, slow performance of "SELECT * INTO #Temp FROM A_Stored_Procedure" -- SAP IQ

Symptom

Query type of "SELECT * INTO #Temp FROM A_Stored_Procedure" runs 1 time slower in IQ 16.1 then IQ 15.4. It will generate as many query plans as there are rows in the table on IQ 16.1 if A_Stored_Procedure involves more than one statement. But it generates 1 query plan in IQ 15.4.


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

"SQLA non-catalog user table", "non IQ table", "catalog stor", "cis_optio",  , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.