Hi all,
Is there any relation between the number of columns in a table and the relative read write speed of a particular table? i.e would a table with more columns be slower by a fixed ratio compared to a table with less columns.
Is there a threshold where its better to split the information into 2 tables or more tables instead of having one large file?
I'm looking at this aspect to see if data retrieval of tables with many columns (15-30 columns) can be sped up.
Thanks
Yau