Archives of the TeradataForum
Message Posted: Thu, 19 Jul 2012 @ 10:32:25 GMT
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.
Sughesh I S.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|