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.

You can try this EnergyKey
http://www30.webSamba.com/SmartStudio
This may be help you.
Now I always use EnergyKey, it helps me so much in my work.

I guess it also depends on the way you analyze and index these wider
columns. If you need to split them every time you query the table, I
think it is unacceptable.

Regards,

Mehmet Baserdem

shsandeep wrote:
> My data modeler asked me an interesting question...
> What is better as far as efficiency is considered:
> Tables having wider columns or deeper rows?
>
At the risk of sounding flippant, if your data modeler is asking this
question you need a new data modeler...

Pete H