Dear all,
Does anyone know the maximum amount of columns of a table in a database? Currently, I am using SQL Server 2005. [*1] Is it normal to have 50 columns in a table? I wonder about the optimization of query processing. [*2]Should I split them into several tables to optimize query processing time? [*3]But if I split them, will it guarantee that my query processing time will be faster? As we know, if we split it into several tables, there must be tables relationship that will effect query processing time. [*4]Should I use index for important fields in the tables?
[*4]What is the normal amount of columns in a table that will keep query processing time high? How can we investigate it? Maybe you have good ideas.