1 First check the table has enough extents to accomodate the 70M rows, if not create the extents.
2 Sort the data file based on the primary key.
3 Create the index after the load.
4 Also consider Parallel Load with DIRECT option.
|
Results 1 to 3 of 3
Thread: Partitioning question againThreaded View
|
Click Here to Expand Forum to Full Width |