SQLTeam.com | Weblogs | Forums

https://www.brentozar.com/pastetheplan/?id=H1rMn9evM

sql2016

#1

https://www.brentozar.com/pastetheplan/?id=H1rMn9evM

The second nested loop is warning that there is no join predicate. I'm still new to this so I'm confused. Is that because I am using a CTE to determine the values for two of the attributes? This presentation table is used in more that a few reports, and I don't want to create a second one for this very unique one.

Sometimes I feel like the Scarecrow and sometime like the Tin Man, but never the Lion.
Thanks,
SM


#2

I think you may be seeing nested loops since the estimated row counts are small. The CTE is not a factor, it's just another way of writing a sub query, in your case.