Re: need help for partition on tables with foreign keys
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
Subject
Views
Written By
Posted
240
June 05, 2022 06:07PM
136
June 05, 2022 07:45PM
Re: need help for partition on tables with foreign keys
109
June 06, 2022 11:22AM
108
June 06, 2022 02:42PM
108
June 06, 2022 04:02PM
105
June 06, 2022 05:16PM
103
June 08, 2022 08:23AM
106
June 08, 2022 10:22AM
Sorry, only registered users may post in this forum.
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.