As described in https://debezium.zulipchat.com/#narrow/stream/302529-users/topic/Poor.20query.20performance.20on.20incremental.20snapshot.20.2Bcomposite.20PK

We noticed progressively poor performance during the incremental snapshot of a N-N table with composite primary key

After adding OPTION(RECOMPILE) the performance issue was completely fixed which notes a parameter sniffing problem

OPTION(RECOMPILE) is not a silver bullet in that it can cause CPU pressure on the database due to execution plan recompiles on each SELECT statement

With that said it would be nice to have it as an option with the default of not recompiling

I can try putting a PR together for this but I'm not a java guy