Long Running with inner Join
I take a look from execution plan, the Actual Number or Row of Lazy Pool is very high, I don't know why the Actual number of row is higher than the number of row of table.
Can you help to found what problem with this query?
the right side (the b side) isn't sargable and will force the index scan that is in the lower branch. If that is really the only way to make this join, you may need to create a computed persisted column based on that expression and then index that new column.