SAP Knowledge Base Article - Preview

2655561 - IQ 16.1 Perf slow "SELECT * INTO #Temp FROM A_Stored_Procedure"

Symptom

"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

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.