BTET makes all the queries running between BT and ET as single transaction . if any of query fails than the entire set of queries will not be commited.
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 can’t be used everywhere in BTET processing , but these statements can be given towards the ed of BTET transaction.
Using large number of BTET caued transient journal to grow and has tendancy for system restarts.
No comments:
Post a Comment