-- increase cpu_tuple_cost to force parallel query set cpu_tuple_cost = 1; select * from part where ( p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG') and p_size between 1 and 5 ) or ( p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK') and p_size between 1 and 10 );