feat(bench): add bench with join type and cache workload

feat(bench): add bench with join type and cache workload #39021