Forum Discussion
Reconciliation
Thank you for the solution.
It does work (of course we need another column equal to the total values of the combination), but for the case facing many rows, it is too time-consuming.
Imaging the case of 100 rows (which is not too much) in the bank table, the combinations are too much.
Do you think it is possible to increase the efficency in another way?
While you cannot cheat combinatorics, the results are immutable. I only computed them as a finger exercise. For better performance you want to have them precomputed. The actual value aggregation and comparison does not grow as exponential as it is less and less likey that values match. Not sure if it is linear (only real world data can tell) but definitely not exponential.
In real life the statement timing constraints will play a much larger role.