sql server mseq: Hi all
Is there a limit on no of columns in a table. How it will affect the performance of a query. What is the optimum max no of columns a table can contain

[quoted text, click to view]
(snip)

Hi Hari,

There is in indirect performance effect.

Adding columns to a table usually increases the avarage number of
bytes per row. This means less rows can be stored in a page. More
pages to be read when the table is scanned, lower cache hit ration
when specific rows are retrieved through an index.

Best, Hugo
--

Hi,

Columns per table : 1024

How it will affect the performance of a query:

Columns in a table will not affect the performance of the query in anyway,
The performance will be affected based on TSQL
statement and Index you are using.

What is the optimum max no of columns a table can contain?

There is no such restrictions on this.

Thanks
Hari
MCDBA



[quoted text, click to view]
performance of a query. What is the optimum max no of columns a table can
contain.
[quoted text, click to view]