Will Number of columns in a table can affect performance in SQL server?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Elliott Whitlow » Will Number of columns in a table can affect...

Will Number of columns in a table can affect performance in SQL server?

Rate Topic

Display Mode

Topic Options

Author

Message

totamilarasi

Posted Thursday, June 17, 2010 3:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 17, 2010 9:45 PM
Points: 1, Visits: 1

Currently I am involved in an ERP application development. In that, few of the main tables having more than 50 columns. Instead of creating multiple tables (Normalize) we add columns in existing tables to satisfy the functionality and reduce coding efforts. So the Data is now centralized into a single table.

Can someone tell me Will this affect query performance?
What would be the advisable number of columns in a Table regarding performance ?

Regards,
tamil

Post #938742

« Prev Topic | Next Topic »

Permissions