Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Oracle Fusion Cloud - Partition large tables
Summary: Looking to partition large tables e.g: HWM_TM_REC
Content (required): We have quite a few reports that are based on the table HWM_TM_REC to get the reported time (excluding breaks). However the performance of these reports is degrading off-late, as the volume of the data is increasing in this table. Is there anyway to get these tables partitioned by week.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0