Partitioning strategy for index - LOCAL or GLOBAL
Hi,
We are converting one of our heap tables (TRX_TAB) into a partitioned one
The table has 2 B-tree indices and one Primary Key Constraint
FIrst index is based on a single column - TRX_ID
Second index is a composite index consisting of 2 columns; 1. CUST_ID and 2. TRX_DATE (in that order)
Primay Key is based on a single column - TRX_SEQ (this is based on oracle sequence)
There are 40 other columns which are varchar2 data type and couple of DATE data type
The database os OLTP and the table is used to store transactional data, dating back to year 2002
0