Using Fillfactor

I'm about to build two indexes: 1 unique with datatype serial and 1 non-unique with datatype datetime year to second, Am I right in thinking I use less pages using a fillfactor greater than the default of 90. As both columns will only ever have increasing values the index keys will allways be placed at the end of the index meaning I don't need to take index split pages into consideration . Regards Colin There are 10 types of people in the world, those that understand binary and those that don't sending to informix-list

You will use slightly less pages but and index has a root node, branch and leaf nodes. As you add more keys the branch nodes get filled up and eventually page splits occur on them.