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.