MLOAD with secondary index

Tools
Enthusiast

MLOAD with secondary index

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.

Please give me the solution as soon as possible.

rgrds,
Shivtera
4 REPLIES
Enthusiast

Re: MLOAD with secondary index

MLOAD with secondary index
Enthusiast

Re: MLOAD with secondary index

Something to say? Add your comment here.
Senior Apprentice

Re: MLOAD with secondary index

Based on the indexname i guess MLoad complains about a USI.
And yes, it is possible, you can do the drop within the laod script, too.
Just have a look at the MLoad manual.

Dieter
Enthusiast

Re: MLOAD with secondary index

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).