SQL Server Statistics 101

SQL Server Statistics 101

Cover

Statistics are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are at the core of query optimization and can have tremendous effect on query plan selection.

Poor statistics, whether they are skewed or incorrect, can cause massive performance problems when they lead to selection of a bad plan.

This white paper discusses how SQL Server uses data findings, and how you can view them to gain a better understanding of the information they contain. Topics include:

  • Viewing statistics data
  • Maintaining Statistics
  • Parameter sniffing
  • And more
Vendor:
Idera
Posted:
18 Jul 2014
Published:
18 Jul 2014
Format:
PDF
Length:
12 Page(s)
Type:
White Paper
Language:
English
Already a Bitpipe member? Login here

Download this White Paper!

By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Safe Harbor