All Questions
2 questions
0
votes
1
answer
90
views
Best way to design for one-to-many code values in Oracle
We receive several millions of records per day on temperature metrics. Most of the pertinent metadata for these records is maintained in a single partitioned table by date (month). We are going to ...
- 7
6
votes
1
answer
600
views
One large table partitioned and then subpartitioned or several smaller partitioned tables?
I currently have several audit tables that audit specific tables data.
e.g. ATAB_AUDIT, BTAB_AUDIT and CTAB_AUDIT auditing inserts, updates and deletes from ATAB, BTAB and CTAB respectively.
These ...
- 17.6k