ESTIMATEFULLDBSIZE

Estimates the number of blocks a full calculation (CALC ALL) of the database creates, based on the number of blocks that exist before calculation. The database can have all data loaded, or a random sampling of data.

Syntax

ESTIMATEFULLDBSIZE

Notes

Example

Assume that you have fully loaded Sample Basic. Use this command before calculation to predict the number of blocks that would be created.

estimatefulldbsize;

Estimated count of blocks after full calculation = 335

Time elapsed to calculate this estimation = 0.02 seconds