4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Statistics, Estimation & Plan Caching-The big three!

In this session we will take an in depth look at statistics, how they are built, stored and used. We will go over why they are so important and what role they play in selecting a query plan. We will also take a look into estimation and how this affects query plan selection and how estimation and statistics tie together.

Also in this session we will take a look into plan caching, what it is, why it is done and how it can be both a help and a hindrance.

Using lots of demos and examples attendees will leave the session with a greater understanding of these three key areas and also the tools and techniques to work with and understand them in their own environments
Presented by David Morrison at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Dave Morrison is senior BI consultant for Itelligence. Having worked in the IT industry for around 15 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
  • Video
    The video is not available to view online.