SAP Knowledge Base Article - Preview

2594175 - Table with compressed lob column uses more space when populating table via view - SAP ASE

Symptom

  • Table with compressed text column and
  • lob_compression = 0
  • sp_spaceused shows more space used when data is inserted through the view rather than directly into the table:

    • Data inserted directly into the table:
      sp_spaceused myTable, 1
      go

      index_name      size         reserved         
      -------------------- ------------  -------------
      idx1                         8 KB        64 KB           
      tmyTable            804 KB     832 KB        

      name          rowtotal    reserved   data   index_size   
      -------------- ------------- -------------- --------  --------------
      myTable            200      928 KB   8 KB    812 KB

    • Same data inserted into the table through the view

      sp_spaceused myTable, 1
      go

      index_name      size         reserved         
      -------------------- ------------  -------------
      idx1                         8 KB        64 KB           
      tmyTable          4804 KB    4848 KB        

      name          rowtotal    reserved   data   index_size   
      -------------- ------------- -------------- --------  --------------
      myTable            200     4944 KB  8 KB   4812 KB


Read more...

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.