MySQL Forums
Forum List  »  Partitioning

Re: need help for partition on tables with foreign keys
Posted by: Johnson WIlson
Date: June 06, 2022 11:22AM

Thank you for your reply!

the table is almost 800gb in size, with past 15 years of data
we typically just query last 12month, and always needs to join between transaction and transaction_event table,
we are also thinking about purging data which is more than 15 years old every year

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.