I'm trying to follow these steps: Space estimation
to estimate the size of my table that I'm creating. I specified an INITIAL as 1M and using the steps above I have the following estimations:
Rowsize = rowheader + sum of columns = 3 + 99 = 102 Rowspace = Rowsize + SB2 = 102 + 2 = 104 Num rows per block = FLOOR(7674/104) = 73 Number of blocks = 1000000/8192 = 122
However from here I wasn't sure what to do to finish estimating the table size as I had number of rows per block, row size and row space. I tried the following but I wasn't sure if it was correct:
table size = number of blocks * (number of rows per block * rowspace) = 122 * (73 * 104) = 926224 which is close to the INITIAL I set. I also wasn't sure if I should be even setting an initial and if the estimated table size should be the initial, but then I don't know where I would get the number of blocks from..
I have not created the table and I am trying to estimate it's size before creating it.