Symptom
- You are running SAP Business Suite on SAP ASE. When checking the Estimated LIO and Estimated PIO of a SQL statement from 'Access Plan', the Estimated LIO and Estimated PIO of 'IndexScan' operator always shown as '0'.
- For standalone SAP ASE system, when you use 'set statistics plancost on' to show the plancost, the Estimated LIO (el) and Estimated PIO (ep) of 'IndexScan' shown as '0'.
- The ASE configuration parameter 'max parallel degree' is set to a value larger than 0. You may confirm the current setting by:
sp_configure 'max parallel degree'
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
SAP Adaptive Server Enterprise 16.0
Keywords
PIO, LIO, Estimated, explain, access plan, plancost, el, ep, parallel, 0, zero , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.