since we have valid table partitioning and constraints, we can use
simplier logic with these