SQL Server Performance Forum – Threads Archive
Table fieldsI 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.