RE: Informix: Modify Next Extent Size of a Primary Key Index
Posted in 2026
Wilhelm: You are correct, there is no "ALTER INDEX <name> NEXT EXTENT 10000;" statement available. You cannot change the extent sizing of an existing index. To your direct question, you cannot update a system catalog table (ie sysindices in the database) and the pseudo tables in sysmaster are not real tables but rather windows into volatile shared memory, so you cannot update them either. I have entered an RFE (Request for Enhancement). I suggest you and everyone else vote for it: https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-718 Art You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.ibm.com/community/user/preferences?section=Subscriptions. To unsubscribe from this community discussion, go to [link removed]