title: Which is better performance wise - Divide a table to two or increase the column count - Oracle
body: <p>Suppose there is an Oracal table which may have 200 columns and 2000K rows. Suppose I have to add a new column to the table. Since the column count is on the high side (even though the max column count is 1000 i think 200 is high side) I can create a new table with the primary key columns and my new column or I can add the new column to the existing table. Which will be performance wise better. Which will be overall better design. If you can elaborate and lead me for more information it would be better. Thanks in advance.</p>