No. | Timing for collecting statistical information | Statistical information that is collected |
---|
deallocate | tran |
---|
1 | When the preprocessing results become invalid if the following SQL statements are executed:
- DEALLOCATE PREPARE statement
- PREPARE statement
- EXECUTE IMMEDIATE statement
| Preprocessing results that are invalidated | Preprocessing results that are invalidated |
2 | When committed | Preprocessing results that are invalidated by commit | All preprocessing results |
3 | When rolled back | Not collected | All preprocessing results |
4 | When the DISCONNECT statement, COMMIT statement with RELEASE specified, or a definition SQL statement is executed | All preprocessing results | All preprocessing results |
5 | When the ROLLBACK statement with RELEASE specified is executed | Preprocessing results that are not invalidated by rollback when the ROLLBACK statement with RELEASE specified is executed | All preprocessing results |