Big Data – Not so Big -Guidance

sbarley02 2017-04-11 18:45:05

Hi, I see where a lot of data appears to be picking up, however, not sure why so many rows as the tables don't have that much data in them(i.e. 1M versus 64M rows). I would appreciate any guidance anyone has to offer as far as making this query more efficient. Thank you in advance. -Scott

Aaron Bertrand 2017-04-11 19:36:29
Any chance you could generate an actual plan from within Plan Explorer? Non-anonymized would be great too, as it would enable things like Index Analysis and also the ability to see how all the ? constructs in the statement are actually being populated.