Improved Workload Management implementation that no longer needs to be tuned via the
workload_engine variable; this variable is now deprecated.
management_ expected_ aggregators
Support for multi-statement transactions that use distributed joins.
Support for multi-statement transactions that write to a database and then read from a different database.
Added a session variable
node_that specifies the number of threads per node to use for columnstore table scans.
degree_ of_ parallelism
Queries that use the
INfilter on shard keys now perform better.
Hash joins that use reference tables now perform better.
data_engine variable can now be set to
conversion_ compatibility_ level
0 This allows errors to be thrown for more invalid type conversions, instead of doing implicit type conversions, where the user could see unexpected results.
Now, a maximum of 1024 tables can be written to in a transaction.
Last modified: April 24, 2021