Why does changing an account name field change the execution plan so much?
The query plan changes quite a bit with this one account name which is the attached plan. When using all other account names the plan changes to use a hash match and doesn't seem to do the RID lookups.
I'm not exactly sure how this plan can vary so much? The plan doesn't suggest any missing indexes, though it could probably stand a clustered index. Any ideas?
I'd also consider doing this to remove the RID lookup on [Table2] columns.