Hello,

I'm having a tough time understanding what ANALYZE TABLE does.
Mysql.com says "ANALYZE TABLE analyzes and stores the key distribution for a table"

Key distribution being index or indexes? Why does it store it, isn't it stored already when index is created, or when row is inserted (if index already exists). Already stored and waiting to be invoked by the Opimizer?