In the previous chapter, you learned about indexes. It was mentioned that the optimizer evaluates each index to decide whether to use the index or not. How does it do that? That is largely the topic of this chapter where index statistics, how to view information about the index statistics, and how to maintain the statistics are covered.
The chapter starts out with a discussion of what index statistics are and how InnoDB works with index statistics. Then you will learn about transient and persistent statistics. The rest of the chapter covers how you can monitor the ...
