G
George Potemkin
Guest
A few large tables and their indexes: -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.Table1 23121895150 2.2T 38 24707 104 23125036358 14.0 1.0 Table Index Fields Levels Blocks Size % Util Factor PUB.Table1 Index1 22 5 5 126307653 594.5G 61.9 1.8 Index2 23 5 5 117620303 519.3G 58.1 1.8 ------------------------------------------------------- -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.Table2 16210782602 2.0T 89 31975 137 16212363909 4.9 1.0 Table Index Fields Levels Blocks Size % Util Factor PUB.Table2 Index1 103 2 4 1674840 7.3G 57.2 1.9 Index2 104 7 5 30604893 132.9G 57.1 1.9 Index3 105 5 4 8992056 36.1G 52.8 1.9 Index4 106 3 4 1347838 6.2G 60.3 1.8 Index5 102 6 5 49186263 225.3G 60.2 1.8 ------------------------------------------------------- -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.Table3 8644278754 1.3T 44 31966 170 8644502338 159.0 1.0 Table Index Fields Levels Blocks Size % Util Factor PUB.Table3 Index1 9 3 4 8335147 19.9G 31.4 2.4 Index2 10 3 4 3982408 16.9G 55.7 1.9 Index3 8 6 5 52376577 241.2G 60.6 1.8 Index4 11 2 4 13891121 56.6G 53.6 1.9 ------------------------------------------------------- -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.Table4 8835112454 598.5G 34 31903 72 8835474203 36.0 1.0 Table Index Fields Levels Blocks Size % Util Factor PUB.Table4 Index1 101 4 5 30743601 137.3G 58.7 1.8 Index2 100 3 5 40316244 189.0G 61.6 1.8
Continue reading...
Continue reading...