Table fields | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Table fields

I am working on a project where 4 joint tables consist in total of over 100 fields. The sql statement looks in the joint tables to produce the result. Can you please let me know which is better for memory consumption and for speed of download of information to use the joint tables or to consolidate the fields of the 4 tables into one table. Thanks salimlallas
Consolidating the fields into one table would perform better. In cases where you can’t do this, what I would do is, Create a view with this join condition and make it an indexed view.
Better to check query execution plan as well for more information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.