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
goindex_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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.