Re: Actual row size of an index

That mistake (incorrect claim of not more than 255 keys per index page) was mine - there isn't a limit on the number of keys per index page. Probably some other people have already said as much, but I've not read the more recent messages yet - and I'm quite willing to 'fess up to (a) top posting and (b) mistakes when I make them. On Jan 18, 2008 9:50 AM, Art S. Kagel (Oninit LLC) <art@oninit.com> wrote: > MICHAEL FAVOLE wrote: > > Thanks for the reply Art. We tested with a 16k size for our critical indexes > > and had positive results. > > > > I am a bit confused about one thing though. In a chat with the labs > > presentation (IBM Informix Dynamix Server 2005-11-02 slide 10), Jonathan > > Leffler indicates that there is "Still a maximum of 255 keys per index > page". > > So this is probably not correct, agree? > > > > Dunno now. That's not my understanding, but I've been wrong before - > mostly when I contradict Jonathan ;-) > > Jonathan? Comments? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/ NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.