DB design for billon rows tables
the table structure of 1 billion rows is
TRIP_SUMMARY_ID NOT NULL NUMBER(12)
TRIP_SUMMARY_NBR NOT NULL VARCHAR2(12)
KM_DRIVEN_QTY NUMBER(6)
DATA_RANGE_START_TS NOT NULL DATE
DATA_RANGE_END_TS NOT NULL DATE
VEHICLE_DEVICE_ID NOT NULL NUMBER(12)
SYSTEM_CREATE_TS NOT NULL TIMESTAMP(6)
SYSTEM_LAST_UPDATE_TS NOT NULL TIMESTAMP(6)
the table structure of 13 billion rows is
BEHAVIOR_SUMMARY_ID NOT NULL NUMBER(12)