Re: Index Sizing

Posted in 1999

Mark Collins — Mon, 24 May 1999 09:54:19 -0600 — source: Informix-list mailing list archive (1991-1998)

> Index Sizing IDS 7.24 > > I am looking to size a table, can anyone advise on the method I > should apply to calculate the size of an index per row or direct me > to a manual section. Section "Estimating Index Pages" in the manual Peformance Guide for IDS. In the 7.3 version of the manuals it is on page 4-13. Basically, for a unique index, size per row is keylength + 9 bytes for attached indexes, keylength + 13 for detached. Mark Collins mcollins@us.dhl.com The problem lies in how easily and dangerously we forget that manipulating things is not the same as understanding them.