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 ?