SAP Knowledge Base Article - Preview

2836171 - Large "unused space/pages" in a table

Symptom

  • A table size is
    -251GB and its unused space is 114GB 
    -its data size is 800MB
    -its index size is 136GB

  • sp_spaceused says


name rowtotal reserved data index_size unused
----------------------- -------- ------------ --------- ------------ ------------
XXXXX 14289958 251589480 KB 806716 KB 136465640 KB 114312512 KB


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.