Bug 4012 - Extend storage() function with garbage size
Summary: Extend storage() function with garbage size
Status: NEW
Alias: None
Product: SQL
Classification: Unclassified
Component: all (show other bugs)
Version: -- development
Hardware: All All
: Normal enhancement
Assignee: SQL devs
Depends on:
Reported: 2016-05-23 23:49 CEST by Ying Zhang
Modified: 2016-07-31 15:08 CEST (History)
1 user (show)


Note You need to log in before you can comment on or make changes to this bug.
Description Ying Zhang cwiconfidential 2016-05-23 23:49:49 CEST
Just to not forget:

Currently, the "columnsize" returned by the storage() function shows the actual size of the file of the corresponding BAT, i.e., this size includes all values that have been deleted (by UPDATE or DELETE) from this column earlier.

It would be useful to extend the storage() function to also show the total size of the deleted values.
Comment 1 WARREN MASTER 2016-07-31 15:08:58 CEST
is there any other way that i can determine the size of the deleted records?