Re: Index "Fillfactors"

This is a multi-part message in MIME format. --------------32E55835691E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Greg Moye wrote: > Dave - I think I have (on)checked right after dbimport on 7.10.UC1 and 7.12.UC1. Ah, and now you provide the critical piece of info that had been missing! Dbimport will build the indexes FIRST, then load the table. Since FILLFACTOR only applies at the time the index is built, you are not going to see any difference in how sparse the leaf nodes are packed. Try rebuilding one of the indexes after the dbimport and running the oncheck. I'm sure you will find a very different use of space. -- 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. --------------32E55835691E 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. --------------32E55835691E--