Re: Sotirng data in row versus storing the same in column

Arijit Mukherjee wrote:

> All,
> I am unaware of the advantages and disadvantages of storing huge lot
> of data in rows or columns.
> The number of columns in tables could grow to a large value -
> somewhere around 600 or more. However, this is not necessarily the only
> reason why there will be lots of data if we store the data in row format
> - as even storing data in column format will result in quite a lot of
> rows.
> So, I want to know - is there a sort of benchmarking information
> that could help in understanding which way of storage would be best - so
> far as performance is concerned?
> Please note we will be using indexing in either case to improve
> database response time.
> Thanks in anticipation,
> Regards,
> Arijit

Data normalization is what is important. In a properly normalized schema I doubt that you could create a table with more than 50-60 columns without making a huge effort at it. 600 columns is beyond anything I have seen since working with flat-files on mainframes.

If your preparation work is done properly ... this issue will likely cease to exist.

Daniel Morgan Received on Thu May 16 2002 - 11:39:11 CDT