I think this is because the query first has to join the tables and then runs the where clause on that, so if you can reduce what is required to join then that’s the fasted way to get the results/do the update. I know this question is old, but I hope this can still be…