Oracle database implicitly commits the current transaction before and after every DDL statement.
ANALYZE information on a table, index or a cluster also comes as part of DDL.
Suppose you have updated a table and havenot COMMITed the changes. Now in the same transaction, if you perform ANALYZE operation, the entire transaction, which includes theses changes, gets COMMITed
No comments:
Post a Comment