×

SQL SATURDAY 962 Richmond – Virtual, United States

Date/Time: Saturday, April 25, 2020 10:15 AM to 11:15 PM EST
Location: Virtual

View Event: Think like the Cardinality Estimator

SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next.  Knowing how CE generates these numbers will enable you to write better TSQL code and, in turn, influence the type of physical operations during query execution.  Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data.  Do you know how the CE generates these numbers?  What happens when you have multiple predicates, range predicates, variable values that are “NOT KNOWN” to the optimizer, or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using a value that is outside of the histogram range? 

In this session, I will show you how CE estimates in all of these scenarios, and you will walk out better equipped to tackle those nasty, hard to solve query plans.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

Got stack dumps? Check out the latest version of the SQLCallstackResolver from @arvisam ! ... https://github.com/arvindshmicrosoft/SQLCallStackResolver/releases/tag/2.0.1

What an honor and privilege to be speaking at @ROCSqlUG

Thursday, August 13, 2020
19:00 - 21:00 EDT

The Magnificent ... Seven - Intelligent Query Processing in SQL Server

Registration details:
https://rochesterpass.pass.org/

#sqlpass #sqlserver #sqlserver2019
#mvpbuzz

@timweigel @SqlWorldWide @sqlpass The game changer that I found for SQL Saturday Iowa 2020 was to fully embrace the ... online event and stop thinking of it as an "in person" event presented online. We found innovative ways around many of the online event challenges.

The great staff we have didn't hurt either!

@timweigel @SqlWorldWide @sqlpass In person is great for a rock solid paywall.

In person events allow me to see people ... who I love to talk to but who live in places I rarely get to visit... @SQLInTheWild, @rob_farley, and @jesus_gilv jump right to mind, among a full on hoard of European friends.

Load More...