My data modeler asked me an interesting question...
What is better as far as efficiency is considered:
Tables having wider columns or deeper rows?

I answered: 'It depends' on the total size of the data to be fetched (row
width * number of rows).

But then I thought that wider columns would be better since DB2 would try
to fit the entire row onto a single page and thus less reads. (obviously
it should be within the page limit).

Just my thoughts, could be totally wrong.
Let me know your views.

Cheers,
San.