G
George Potemkin
Guest
> It would be great to be able to get that same info for B1. viewB2 reports the objects in B1 as well as in B2 Exampe: proutil sports -C viewB2 Area "Customer/Order Area":8 - Primary Buffer Pool Object Enablement Size Type Object Name ----------------- -------- ------- ------------ Default 7 Master Area.Control-Object:0 Default 8 Table PUB.Customer:2 Default 16 Table PUB.Order:4 Default 32 Table PUB.Order-Line:5 Default 8 Index PUB.Customer.Sales-Rep:16 Default 8 Index PUB.Order.Cust-Order:21 -------- 79 prostrct statistics sports Database Block Usage for Area: Customer/Order Area Active blocks: 79 ... Records/Block: 32 Cluster size: 8 > Once you have the number of levels how do you calculate the estimated table size? Number of records ~ 1000 ^ levels Number of levels in the index tree (1, 2, 3, 4, 5, 6).is a kind of the table's size gradation: "very small", "small", "medium", "large" and "huge".
Continue reading...
Continue reading...