Forum Post: RE: Cluster Size 64 for Index Areas

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
Found db with 6 levels in an index tree: -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean Count Factor Factor PUB.table3 8057647115 1.3T 47 25481 173 8057759806 2.1 1.0 Table Index Fields Levels Blocks Size % Util Factor PUB.table3 Index1 9 3 5 13190287 18.4G 36.8 2.3 Index2 10 3 5 8302850 16.0G 50.8 2.0 Index3 8 6 6 92560806 219.1G 62.5 1.8 It's the different instance of the same table as Table3 above where: Index3 8 6 5 52376577 241.2G 60.6 1.8 The difference is db blocksize: 4K vs 8K.

Continue reading...
 
Status
Not open for further replies.
Back
Top