row limit for fragment table with rowids

Hi, What is number of rows limit for fragmented table created with rowids option? I'm using IDS 11.50FC. Regards, Direk

Original post: Hi, What is number of rows limit for fragmented table created with rowids option? I'm using IDS 11.50FC. Regards, Direk Response: The documentation states that the with rowid option is using an extra 4 bytes of storage, so I'm going to assume integer. Based on that, I would expect the limit to be 4294967295 rows and once you go above 2147483647 rows, the rowids could possibly flip to be printed as negative numbers (I'm not sure if it's going to be treated as a signed or unsigned integer). But since it's backed up by a unique index, that would be the limit to the number of rows you could have total in the fragmented table. Jacques Renaut HCL Informix support