Why is BTET transaction processing overhead in Teradata?
Answer:
- BTET makes all the queries running between BT and ET as single transaction . If any of queries fails then the entire set of queries will not be committed.
- BTET also has an overhead with locking , since it holds locks on tables till the ET is occurred or all the queries have executed successfully
- DDL statements cannot be used everywhere in BTET processing , but these statements can be given towards the end of BTET transaction.
- Using large number of BTET caused transient Journal to grow and has tendency for System Restarts
No comments:
Post a Comment