Table with large number of columns pros and cons ?

The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Junior Supporter

Table with large number of columns pros and cons ?


We have a situation in which we are designing a tabe which will have 250 columns which is arounf 1 Tb table as this is a business requirement. What are the pros and cons of having such large number of columns in a table ? I can think of below

1. performance wise it will be good as you need not join to another table to get the column values and since we have a PPI performance should not be concern

2.I/O will increase as more data needs to be read in one data block.

Any other consideration ?


This is somewhat urgent, so a quick answer will really be great.