Insert is taking so much time

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

Re: Insert is taking so much time

Adding partitioning might help.

Can you show the table DDL plus the Insert/Selects?

Why do you need to run so many iterations?

Enthusiast

Re: Insert is taking so much time

Could it be that your last (17.th) iteration has skewed input, with a lot of duplicates of your primary index definition?