General
Enthusiast

## Insert is taking so much time

Hi,

I'm running a insert query which inserts data in 30 iterations. After 16 iterations the record count in the target table is 3 billion. The 17th iteration is taking alomst 7 hours to load the data. Is there any way to speed-up the process time (load time).

Thanks,

Vinay.

5 REPLIES
Enthusiast

## Re: Insert is taking so much time

If you don't have a unique index, try to create the table as a Multiset table. Then Teradata does not need to check for row dupilicates at every insert.

Enthusiast

## Re: Insert is taking so much time

And check the target table for skewing.

Enthusiast

## Re: Insert is taking so much time

Thanks for your reply Bjorn. I'm using multiset table only and when I checked for skewing, it's not skewed.

Junior Contributor