Re: Number of Columns in a Table & SQL Performance ?

Vivek,
if this leads to chained rows (which is not unlikely at 400 columns and small blocksizes) you will see an affect in performance for sure. Otherwise there are pros and cons, depending on your actual data and access.
I personally have not seen any useful table with 400 columns yet, but your case might be reasonable.
There is also a little cost and performance penalty accessing the later columns, as oracle has to traverse all columns to reach the latest requested, so choose the column order wise. 

hth,
 Martin


Am 09.03.2009 um 14:19 schrieb VIVEK_SHARMA:


Folks
Does the number of columns in a table affect the performance of SELECT/INSERT/UPDATE in OLTP Transactions. 
If so, why?
NOTE - Merge of 2 existing tables each has 200 columns approx into a single Table is being planned.. 

Thanks in Advance

Vivek

Other related posts: