Getting Diff plan between primary and secondary replica, also between plan explorer and SSMS

sqlworldwide 2016-12-06 22:33:26

I am uploading 3 plan here.
1st one I am getting from primary node of replica collected running the query directly from SQL Sentry Plan Explorer. Finishes in less than a second.
2nd one I am getting from secondary replica which has a spool and where it is incurring the io and time.
3rd one is from ssms and running against primary replica. To my utter surprise it also has spool where as running from plan explorer I get a hash join.