Tue, Oct 11 2016 12:30 (UTC+10:00) Brisbane
Statistics and Query Plans
If you want to tune queries, you have to look at query plans and you have to understand what they’re showing you. One thing people look for when tuning is “bad cardinality estimates”. If you’ve wondered what that means, and you want to understand how the optimizer uses statistics when creating a query plan, then join me for this session on statistics and query plans. We’ll set the stage with a review of what statistics are, then see how the optimizer uses them and where to find that “cardinality estimate” information in a plan. We’ll also cover the various ways statistics can be updated, explore what happens to plans when those updates occur, and ultimately you will see why understanding how it all works is critical when you’re troubleshooting performance issues. Expect lots of demos so you can truly understand what statistics are, how they're used, and why their management is so essential for good performance.
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.
JOIN PASS then add our Virtual Chapter to your list
Please join our chapter by creating a user account. This can be accomplished by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Present to our Chapter
* Send us an abstract, and your biography to DBAFundamentals@sqlpass.org
* Put Speaker Request in the Subject
* Be patient and we will get back to you. We get a lot of emails.
Register before midnight PST July 17 to save $400, plus use our discount code, VC15GBQ6 and save another $150 off the cost of registration. Everyone that uses our code will be entered into a pool of people where one person will win a $500.00 Amazon Gift Card.
Meetings At A Glance
Tuesday, 07/12/16 -- Kendra Little
Register for 3 Skills Every Junior DBA Must Know
Register for High Availability/Disaster Recovery 101