Definition
When to rewrite away deletes
The rewrite costs about one read of the file, and each future read saves about d of one read.
- Deleted fraction
- fraction of the file's rows that are deleted
Worked examples, recomputed
Every number the mechanisms quote for this relationship is recomputed from it, so none of them disagrees with it.
Where it appears
Each mechanism states it in its own names. The general symbol each name stands for is shown with it.
- Table & Storage Maintenance
Who pays for the gap between the order data arrives in and the order it is read in: the writer, every reader, or a background job, and what is the break-even?