How to reduce # of rows read from CallActivity

I am trying to understand why the plan is reading ALL the rows in CallActivity to statisfy this query. Is there a way of improving this. This is my first time submitting a query. If I am not providing enough info, pls let me know. Thanks.

tmp2BD3.pesession (14.1 kB)
avatar image By MichaelK 1 asked Feb 16, 2017 at 04:54 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Feb 17, 2017 at 11:09 PM

Can call_activity_id really be null?

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: Feb 16, 2017 at 04:54 PM

Seen: 32 times

Last Updated: Feb 17, 2017 at 11:09 PM