Re: Index "Fillfactors"

> 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. i just came onto this thread, but am i missing something?? how can it build the indexes first, when the data doesn't yet exist to build the index's on? if you watch a dbimport, you will see that the schema for the table is defined, then it sits for a while, (depending on the number of rows it is loading), and then you see the statements for building the indexes. that sounds strange to me, again, am i missing something? mickm