G
George Potemkin
Guest
Your table: -Record Size (B)- Records Size Min Max Mean 552001843 203.1G 210 1667 395 It uses 29,622,159 blocks Or 18.6 records per block. Cluster size is 512. RM chain: 4,354,789 blocks dbanal.crlim32 2,641,801 blocks dbanal.tosslim 14,587,876 blocks dbanal.baseline The length of RM chain is huge! BTW, the "normal" length of RM chain, IMHO, should be less than two cluster sizes. Don't ever try to run the offline dbanalys! It will take a few days (offline dbanalys completed in one and a half hours). Set Toss Limit to 500 bytes and Create Limit to 300 bytes or so (but I would also check the size of template record - AreaDefrag reports it). I guess there is ONE character field in your table that contributes the most to the record's size. Do you know this field? Best regards, George
Continue reading...
Continue reading...