Archives of the TeradataForum
Message Posted: Wed, 29 Sep 2010 @ 14:38:30 GMT
We do have a below update query, we do not have any PI or USI in WHERE clause.
UPDATE target_table SET col_b = :a WHERE col_c = :ix;
We do execute the above query from DataStage.
They are 30 countries which are started in intervals of 1 minute.
Most of the time ETL jobs use the above query at a time which results in hanging. Due to which each ETL job will take long time to complete.
Please let me know any resolution/suggestion for this.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|