Re: Index "Fillfactors"- Mea culpa!

This is a multi-part message in MIME format. --------------65D49906FB0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Greg Moye wrote: > Dave Kosenko wrote: > > I wrote: > > > Dbimport will build the indexes FIRST, then load the table. > > > > Sorry, I spoke incorrectly in the above. The order is, in fact, to load the table, > > then index it. > > > > snip... > > Glad you weren't right on that one Dave...workarounds were looking pretty ugly.... > > That puts us back to the original question: > > Why do I get indexes that are 40-60% full on average when I specify 80, 90 or 100% > FILLFACTOR? A few additional questions: - What version of OnLine are you using? - Are you dbexporting to disk or tape? -- Dave Kosenko, Informix Professional Services **************************************************************************** While it is true that there is more than one way to skin a cat, the cat himself generally fails to appreciate the differences. --------------65D49906FB0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="IFXDISCL.TXT" ************************************************************************* Note: please do not send me email asking about features, or asking about Informix problems and how to solve them. I answer what questions I can in this forum (comp.databases.informix) when I have the time to spare. For questions on features, call your local sales rep or check out the Informix web site (http://www.informix.com). For technical problems, call Informix tech support. ************************************************************************* Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. --------------65D49906FB0--