-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|