The Query Optimizer uses statistics to create query plans that improve query performance. For most queries, the Query Optimizer already generates the necessary statistics for a high-quality query plan. In some cases, we need to create additional statistics or modify the query design for best results. This presentation discusses statistics concepts and provides guidelines for using query optimization statistics effectively. We will also discuss why this is more important now than in the past