Improve the execution plan
Better to join the configurations to the productions container and after to the jobs table... In that case the partition pruning will be 100% efficient.
Better to join the configurations to the productions container and after to the jobs table... In that case the partition pruning will be 100% efficient.