Controls whether the database server performs a COMMIT before an index is created on a local temporary table.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY PUBLIC OPTION||Yes||Yes, with SET ANY PUBLIC OPTION|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
When this option is set to On, the database server executes a COMMIT before an index is created on a local temporary table. If the commit fails, the operation fails or rolls back. When this option is set to Off (the default), a COMMIT is not performed, which allows a procedure that relies on the index to be used as part of an atomic operation (such as a trigger, UPDATE statement, INSERT statement, DELETE statement, or the FROM clause).