Regarding D1_INIT_MSRMT_DATA Partitioning
(Doc ID 2758921.1)
Last updated on MARCH 11, 2021
Applies to:Oracle Utilities Customer to Meter Base - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
As per DBA Guide the partitioning strategy for D1_INIT_MSRMT_DATA table is as below in case we are not using ILM.
PARTITION BY RANGE (D1_TO_DTTM)
SUBPARTITION BY RANGE (MEASR_COMP_ID)
The sub partitioning is based on MEASR_COMP_ID which is not the Primary Key , The PK is INIT_MSRMT_DATA_ID.
What is the performance gain perspective of using MEASR_COMP_ID instead of INIT_MSRMT_DATA_ID?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document