0

My database table is going to have around 1.5 billion to 3 billion rows.

Splitting that table in many small tables is not going to be an option for me.

My Table schema is:

OBJECT_PRIMARY_KEY VARCHAR2(36) PRIMARY_KEY,

OBJECT_TYPE VARCHAR2(100),

DATE_CREATED TIMESTAMP,

COLUMN_1 VARCHAR2(100),

COLUMN_2 VARCHAR2(100),

COLUMN_3 VARCHAR2(100),

COLUMN_4 VARCHAR2(100),

COLUMN_5 VARCHAR2(100),

COLUMN_6 VARCHAR2(100);

I want to partition my table on OBJECT_TYPE column where my object type is one of the predefined objects in the list of 2000 objects. And every object can potentially have upto 1.5million to 2 million rows.

What can be the best strategies to partition my table to suite the above requriement?

Wernfried Domscheit
  • 54,457
  • 9
  • 76
  • 110
user3111249
  • 1
  • 1
  • 1
    Isn't this just [list partitioning](https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/partition-concepts.html#GUID-7221F7EC-4AFB-412F-8A4F-766CBE24CAE0), with a list of 2000 partition keys? – Alex Poole Oct 19 '22 at 15:41

0 Answers0