Re: Index full-same problem/diff situation

> Given the way data is loaded into this table, could your suggestion of > decreasing the fill factor make a difference, even when the index is > created before data is loaded? Unfortunately, no. The only thing that the fillfactor trick will affect is the size of the index extent. It does not affect the way the index pages fill and split in this situation. Mark Collins mcollins@us.dhl.com The problem lies in how easily and dangerously we forget that manipulating things is not the same as understanding them.