4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Estimation and Statistics : The Basis of query optimization

At the heart of SQL Server is the cost based optimizer. Stop and
think about that a minute, it attempts to give the “best plan” based on the
cost of the work undertaken. 

How does it know the cost of the work before its done the work ? This isn’t a
conundrum, it doesn’t. It estimates! How does it estimate ? That is statistics. 

This will be a deep dive into how the optimizer makes its decisions to give you
a plan, the things that can go wrong and how you can have influence over these
choices.

 

 
Presented by Dave Ballantyne at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    dave_ballantyne.jpg
    Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years,  the past 15 of which has been specialising within SQLServer environment. 
    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video
    The video is not available to view online.