opt/exec: reduce allocations for counting join algorithms and types

opt/exec: reduce allocations for counting join algorithms and types #34080