SAP Knowledge Base Article - Preview

3222103 - Estimated LIO and Estimated PIO of 'IndexScan' operator always shown as '0' - SAP ASE

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.