Provides an estimate of the number of blocks a database will create after full calculation (CALC ALL), based on the number of blocks that exist before calculation.
ESTIMATEFULLDBSIZE
This command returns the number of blocks a full calculation of the database creates. The database can have all data loaded, or it can have a random sampling of data loaded.
Assume that you have fully loaded Sample Basic. Use this command before calculation to predict the number of blocks that the calculation would create if it were executed. This example shows the command and the output that results:
estimatefulldbsize; Estimated count of blocks after full calculation = 335 Time elapsed to calculate this estimation = 0.02 seconds
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |