Changes in 11.9.2 that may affect user applications and system administration are:
Changes to statistics and query optimization can cause changes to query plans, even for tables where the locking scheme is not changed.
More logging is performed than in previous versions.
For standby or report-processing servers, new syntax is required to dump the transaction log for the production server and bring the database online. It is no longer possible to load a dump that contains open transactions, bring the database online, and then load a subsequent dump of the log.
The update statistics command may run more slowly, because it now performs a table scan as well as scanning indexes. Concurrency is improved, because update statistics with a table name or index name operates at transaction isolation level 0 on data-only-locked tables, and does not acquire table locks on allpages-locked tables.
The update all statistics command now generates statistics for all columns in a table. It performs a complete table scan for each column that is not the leading column in an index. If your system runs scripts that include update all statistics, you may want to replace update all statistics commands with update statistics and update partition statistics commands.
