Eddy_G

CA Tuesday Tip: (CA IDMS) Example of sizing calculations for a system-owned index sorted on symbolic key

Discussion created by Eddy_G Employee on May 22, 2015

CA IDMS Tuesday Tip by Edward Gorga, Principal Support Engineer for May 21, 2015

 

Guidelines and formulas for calculating the space required for an index are documented in the Database Design Guide in the section Allocating Space for Indexes.

The guidelines vary depending on whether the index is sorted on a symbolic Key, sorted on dbkey on unsorted.

An example of using these formulas for calculating the size of a system-owned index sorted on Symbolic key has recently been published. See the details in knowledge base article TEC1754577.

Outcomes