Re: Info on sysptntab table

Tim Owens wrote: > > Anyone know where I can get information on the sysptntab table in the > sysmaster database (Informix 7.22)? > > There seems to be some useful data there, but I can't find any reference to > it in the Informix documentation. It contains current statistical and optimizer data about all partitions (read tablespaces or tables). The key is partnum which is the partnum from systables or sysfragments in the table's database or in the sysmaster:systabnames table and sysmaster:sysptnhdr. Art S. Kagel