select /*+LEADING(r upt upkc utc)*/ r.recname, upt.table_name, utp.partition_name, utp.high_value, upt.interval interval_size INNER JOIN user_part_key_columns upkc ON upkc.name = upt.table_name AND ...