Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 21 Jul 2012 @ 07:22:41 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Insert statement starts OK but then slows down
From:   barb.green

sughesh iyyani wrote:

  Hi Barb Green,  

  As you are trying to load to a SET table, insert will run slower and slower as record count in table increases.  

  This is because, as SET table won't allow entire row duplicate, as you insert new rows to the table TD system should check whether particular row is already present or not.  

  And if row is already present, it won't insert particular row. It won't give any error message also.  

  As this is an automatic process, lot of resources and processor time required to do the same.  

  Initially it work faster and as record count reach millions, it becomes slow.  

  Hope this may help you.  

Thank you

I wasnt looking for help, I was looking TO help. I think my 15 years in the4 Teradata Support Center make me qualified to help.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020