Blog Post

SQL Server Support Blog
4 MIN READ

SQL Server CE: Multiple single-column statistics

Liwei's avatar
Liwei
Icon for Microsoft rankMicrosoft
Sep 07, 2021
The SQL Server Query Optimizer is a cost-based Query Optimizer. For one specific query and tables,  SQL Server creates the query plan based on the estimated rows. Hence, understanding how SQL Server ...
Updated Nov 01, 2022
Version 8.0
performance
EitanBlumin's avatar
EitanBlumin
Brass Contributor
Sep 07, 2021

Thanks for this resource, Liwei!

It's definitely very helpful.

Quick question: what are the implications when upgrading from pre-2014 versions to 2014 and newer? As in, do statistics need to be recalculated? Indexes rebuilt? etc.