Using integrity constraint states in the following order can ensure the best benefits:
1.Disable state.
2.Perform the operation (load, export, import).
3.Enable novalidate state.
4.Enable state.
Some benefits of using constraints in this order are:
1.No locks are held.
2.All constraints can go to enable state concurrently.
3.Constraint enabling is done in parallel.
4.Concurrent activity on table is permitted.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment