SAP Knowledge Base Article - Preview

3258937 - How to get the total size for all the IQ indexes - SAP IQ

Symptom

How to get the total size for all the IQ indexes?

The stored procedure sp_iqindexsize applies for one index and returns the index size in the "Kbytes" column.
There is no straight forward stored procedure or SQL, that gives the total size for all the indexes.


Read more...

Environment

  • SAP IQ 16.0 
  • SAP IQ 16.1

Product

SAP IQ all versions

Keywords

"total size for all the indexes"; "total size"; sp_iqindex; sp_iqindexsize , 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.