Padding

When you use adaptive compression (level=2), specify padding (headroom) to accommodate potential increases in the number of distinct values stored in the Oracle database tables. Doing so can help avoid reanalyzing the data and regenerating the TimesTen schema if the data changes.

Use the padding field in the -compression command-line option to apply a padding factor to adaptive compression. The padding field accepts an integer value from 0 (default) to 1000. This value specifies the percentage increase to apply to the number of distinct values for a column, as determined during data analysis.

For example, suppose you evaluate a column for adaptive compression and the data analysis determines that it currently contains 237 distinct values (including NULL). If you specify a padding factor of 50 (50%), the utility increases the number of distinct values to 356 before evaluating the column for compression.