Innodb and statistics

hi, since analyze table doesn't work for Innodb tables, where does optimizer get statistics needed for making proper query plan from? For example, how does it know which index is more selective or in which order tables should be joined? -- _/_/ _/_/_/ - Rafa Jank [EMAIL

Re: Innodb and statistics

Rafal Jank writes: hi, since analyze table doesn't work for Innodb tables, where does optimizer get statistics needed for making proper query plan from? For example, how does it know which index is more selective or in which order tables should be joined? -- _/_/ _/_/_/ -