Grant Fritchey (8/17/2016)
JarJar (8/17/2016)
...i've added missing indexes for all the joins possible...based on an evaluation of the execution plans to understand where indexes are needed... I hope. Not just a blanket, there's a join, toss an index at it. Please?
yep and all joins benefitted. there were only clustered indexes on the primary key, no nonclustered on any other columns being joined. i also did what is suggested below, some of the indexes are covering indexes.
so far so good....thanks!