 |
 |
Archives of the TeradataForum
Message Posted: Sat, 21 Jul 2012 @ 07:22:41 GMT
| Subj: | | Re: Insert statement starts OK but then slows down |
| |
| From: | | barb.green |
sughesh iyyani wrote:
| | 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. | |
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.
| |
