Informix extents
Posted in 2000
kvdhanesh@hotmail.com — — source: Informix-list mailing list archive (1991-1998)
Hello Gurus, I have a fragmented table with approx 10 million records ( 20 fragments) . Data portion of the table has only one extent per fragment after i did the reorg. But the indexes extents look so weird .. One of the unique index has got 17 extents in one of the fragments. Table row size is 315 bytes and the index key size is 4 bytes ( serial ). Fillfactor is 90. Here is a bit story: When the table was created FILLFACTOR was 70. Latter i dropped and re-created only the indices with a FILLFACTOR 90. Any comments. thanks in advance Dhanesh Sent via Deja.com http://www.deja.com/ Before you buy.