Quality of Index

Folks, Running 7.13 on HPUX 10.10 I'm getting some slow performance. One thing I'm looking at is an index on a big table. I remember reading (maybe even writing) about a quirk about Informix indexes. First, the index is a single (non-composite) index on a char(10) field. The entries are unique, but very similar, like this: 09142630000 09142630001 09142630002, etc. There's a **lot** of duplication in the first six positions of the index. My fading memory seems to remember something about the way that Informix groups the keys together before building the index. Am I just making this up? Extra points if someone refers me to some of my own writing with a RTFM ;) Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------