Originally Posted by db2mtrk
we have two version of databases running on windows.
db2 v8.2 and db2 v9.7 fp 3a.
in v8.2 there is a dms tablespace with 8K page. Only one table in this TBS.
the average row length is 165 bytes. how do I calculate that we are wasting any space or not?
In v9.7 same tablespace with 4K page. again the row length is 165 bytes.
Again I need to see this will fit correctly into the page.
With a row size of 165, you can not possibly be wasting any amount of space that is even worth worrying about, regardless of page size.
What is more import, is how the data is typically accessed and how many rows are in the table. If the data is almost always accessed a few rows (or one row) at at time via an index
, 4K or 8K page size is fine. If the table has a large number of rows which are typically accessed via table scan
, then larger page sizes are better, maybe even 32K.