To avoid sending COMMIT to each table, you can use this operation:
APPLY TOPOLOGY [IN <schema>]
You can also decide to use this operation on a specific schema
- returns the list of tables that requires to be committed
Rights to perform this action
Users are required to be in an admin role to send this command.
If not, the user will get the following error: Error while compiling statement: User XXXX is not in admin role