Re: No of columns in a table

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 10:20:28 +0200

On Tue, 20 Apr 2004 10:48:00 +0530, Hari wrote:

>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.
(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 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)