Index "Fillfactors"

Posted in 1996

Greg Moye — Fri, 15 Mar 1996 14:02:31 -0800 — source: Informix-list mailing list archive (1991-1998)

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. I'm told this might be due to the page splitting process and/or data distribution, and that all indexes are still built top down (bottom up v8??). Pretty amazing huh?? I woulda never thunk it. Has anybody else researched this and perhaps found reasonable workarounds??? gm.