Optimization of Restructure Operations

If a database outline changes frequently, analyze the outline and the types of changes that you are making. Changes to sparse dimensions or attribute dimensions are relatively fast, because only the index changes. Changes to dense dimensions are relatively slow, because data blocks are rebuilt.

These types of restructure operations are listed from fastest to slowest:

• Outline only (no index or data files)

• Sparse (only index files)

• Dense (index files and data files) as a result of adding, deleting, or moving members and other operations. See Outline Change Quick Reference

• Dense (index and data files) as a result of changing a dense dimension to sparse or changing a sparse dimension to dense