Defining transactions
Here you can set the isolation level for data and metadata. Isolation level determines how a transaction interacts with other simultaneous transactions accessing the same tables.
Snapshot
Provides a repeatable-read view of the database at the moment the transaction starts. Changes made by other simultaneous transactions are not visible. Snapshot table stability provides a repeatable read of the database by ensuring that transactions cannot write to tables, though they may still be able to read from them.
Read committed
Enables transactions to see the most recently committed changes made by other simultaneous transactions. It can also update rows as long as no update conflict occurs. Uncommitted changes made by other transactions remain invisible until committed.
Read-only table stability
Defines the 'read-only' access mode when the transactions are only allowed selecting data from the table.
Read-write table stability
Defines the read-write access mode when the transactions are allowed to select, insert, update and delete data from the table.
