Re: Index "Fillfactors" - Results...

Posted in 1996

Greg Moye — Fri, 10 May 1996 13:54:38 -0700 — source: Informix-list mailing list archive (1991-1998)

Greg Moye wrote: > > Has anyone noticed that when v7 (Specifically 7.12.UC1 for me) builds > indexes it usually leaves leaf pages rather sparsely packed?? Averages > of 700 to 1200 bytes free out of 2k bytes is common for me. > > tbcheck -pT output shows this pretty clearly, regardless of what > FILLFACTOR is set to. FWIW, V5 index build looks essentially identical. > snip...... Well - its a bug. With at least some kinds of data (not quite sure what kind, but I apparently have lots of it...) No matter what you set FILLFACTOR to, you'll frequently get indexes that are 40-60% full. Bug is #52950. On the bright side, when it gets fixed, it should cut my (and possibly your...) index page reads by about 40-60% - i'll take that... -- Greg Moye Electronic Data Systems Corp. - Plano TX