RE: What is the maximum number of pages for an index in Informix 11.70?

Art: Until Informix 11.7, I thought that the maximum number of pages for an index fragment was 16,775,134(2^24). But it was totally wrong! I think I need to study the storage architecture again. Thank you for answer. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------

Yeah, I used to think that index partitions were also limited to 2^24 pages, but nope, never were. I had never had a reason to look into it. I found out about 6 years ago during a discussion with a couple of Informix kernel developers. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------Original Message------ Art: Until Informix 11.7, I thought that the maximum number of pages for an index fragment was 16,775,134(2^24). But it was totally wrong! I think I need to study the storage architecture again. Thank you for answer. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------ #Informix