Partitioned table
The partitions are by range on a date column, and there is one partition for each month. After the month is over, there will be no further inserts. There are never any updates on this table. Retention of this data is five years, and records be removed by the partition
The subpartitions are by hash on an “ID” column that is defined as varchar2(64). There are 8 subpartitions for each partition, stored in three tablespaces. The underlying datafiles for these tablespaces are on two disks.
There is a primary key constraint on the table (date + id), using a local index.