[PERFORM] Effect of too many columns

2004-04-12 Thread Rajesh Kumar Mallah
Greetings, Is there any performance penalty of having too many columns in a table in terms of read and write speeds. To order to keep operational queries simple (avoid joins) we plan to add columns in the main customer dimension table. Adding more columns also means increase in concurrency in the

Re: [PERFORM] Effect of too many columns

2004-04-12 Thread Bruno Wolff III
On Mon, Apr 12, 2004 at 17:24:17 +0530, Rajesh Kumar Mallah [EMAIL PROTECTED] wrote: Greetings, Is there any performance penalty of having too many columns in a table in terms of read and write speeds. To order to keep operational queries simple (avoid joins) we plan to add columns in