I have two tables I want to partition.
Orders and Order_items, and I want to partition by month and year. The problem is the order_items table do not have the columns month and year, its link via order_no to the Orders table. How do I partition the order_items table?

e.g.
ORDERS: ORDER_ITEMS
order_no order_no
year item_no
month qty
day value
total_value

Thanks.
Rgds.
Sheryl