Hi, we have many tables with secondary indexes and while loading it's giving error. we have dropped the secondary indexes and loaded the data. Is it possible to include the below statement in MLOAD script?
create INDEX gmrdate_usi_mo_nm (mo_mm) on teradbc.gmrdate.
I will use fastload and ANSI MERGE statement to handle the update/insert/upsert operation. this can help you avoid the index maintenance. Well, with that said, if the update operation involves large quantity of data, it may be slower to have index on the table. Dropping index and recreate may help performance. Mload does not like Unique Secondary Index since the update on the USI is a two amp operation (usi stored in sub table hashed by index value, nusi subtable hashed by primary table's pi).