For large tables, importing the data in sorted over can improve index creation dramatically
-- indexes: nosort option
create unique index IDX_WS_INVOICE on WS_INVOICE
(cust_id,year,freq_code,freq_number,field_number,note_link,record_seq)
tablespace ts120
nologging
nosort ;
|
|
