Re: Index "Fillfactors"

Dave Kosenko wrote: > >snip... > > Indexes are not built top-down, as of 6.x or so. The keys are sorted, the leaf nodes built, then > the rest of the tree is built up from there. > > Are you performing your oncheck immediately after building the index? Keep in mind that if you > use a FILLFACTOR that is very high, say 90-100, then a moderate number of inserts will result in > a lot of node splitting, with the resulting nodes considerably less packed than they were > originally. For fairly active tables, you don't want to use too high a FILLFACTOR - 90 is about > as high as you want to go. For static tables, you can push it higher. > > snip... Dave - I think I have (on)checked right after dbimport on 7.10.UC1 and 7.12.UC1. I'll have an opportunity to check again with 7.12.UC3 for Solaris 2.4 in a few days, so I'll be extra careful to check immediately, then report back....maybe I goofed. I spoke with a couple of consultants at the local (Informix) office who suggested it was due to top down index build (which really floored me...), hence my belief that this might be the culprit. -- Greg Moye Electronic Data Systems Corp. - Plano TX