Changes in query optimization provide greater accuracy than in previous versions in costing some queries, especially those performing nonclustered index scans. In version 11.9.2, you can create statistics on unindexed columns, which can further improve query optimization. You should review any queries that are using forced query plans, especially index or join order forcing, to determine whether forcing is still needed or whether the optimizer can provide an improved plan.
