Removing #MISSING Blocks

You can use the CLEARDATA command to change the value of cells in a block to #MISSING. It does not remove the data blocks. These extra blocks can slow retrieval and calculation performance.

If the #MISSING blocks are slowing performance, perform either action:

Note:

Removing empty blocks improves performance when data values already have been loaded. However, data load process time increases if new values require that blocks be created.