Alter Fragment ... init ...
Posted in 1998
Kenneth Ma — — source: Informix-list mailing list archive (1991-1998)
Hi all:
After I realized there is a table with too many extents (32), I did the
followings:
1) increase the next extent size
2)use 'alter fragment ... init ...' command to reorg this table
Everything looks fine except the output from 'oncheck -pT' command:
number of extents: 1
first extent size: 128
next extent size: 1024
number of pages allocated: 6272
How come there is only 1 extent, but the number of pages allocated is
6272?
Thanks for your help in advance !!!!!!!
Kenneth ma