Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Effects of Large # Fields per Table

Author  Topic  anton Starting Member 5 Posts Posted - 2001-10-25 : 06:41:16 Hi Guys, I'm wondering what the effects are of having a table with many fields, say 50, including fields that are not often used when accessing the table, as opposed to having the user table only have the 15 or so fields that are used alot, and then including the other information in an associated table. Does the number of fields in a table affect the speed of accessing the table, assuming you are not doing "select * " statements? Any input would be much appreciated...