Re: Actual row size of an index

The number of slots on index page is not limited at 255. John = "Art S. Kagel = (Oninit LLC)" = <art@oninit.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Re: Actual row size of an index = 01/18/2008 09:50 [10995] = AM = = = Please respond to = ids@iiug.org = = = 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), Jonat= han > Leffler indicates that there is "Still a maximum of 255 keys per inde= x 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? Art S. Kagel Oninit > Thanks again, > Mike > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =