Row Length

[karmst]

Hi all,

I have a table with 50 columns. However, I wanted to use this table for another part of the application, but there may be only 7 or 8 columns of reuse.

What is the impact of maybe 50% of this table have 8 columns populated with data and the other 50% of the table having most of the columns populated.

Is there a problem with this as far as storage management at a table level is concerned?

Thanks in advance.

Keith

[jdorlon]

it depends on the data types. If you use CHAR datatypes, they will use all of their allocated space regardless of if you put data in them or not. VARCHAR2, on the other hand, will only use the space occupied by actual data.

I am not sure about DATE, NUMBER and other data types....