Hi, I have executed ANALYZE TABLE for myisam tables, but still myisam is showing more scanning of rows as compared to innodb. What does ANALYZE TABLE command exactly do for myisam storage engine.
Thanks Krishna On Wed, Apr 2, 2008 at 9:48 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Wed, Apr 2, 2008 at 8:52 AM, Jay Pipes <[EMAIL PROTECTED]> wrote: > > > The MyISAM isn't scanning more rows. It's that the InnoDB "rows" output > in EXPLAIN is an estimate and the MyISAM one is accurate... > > > > -jay > > Also, if he was testing one storage engine vs another he might have > dumped the table and reimported with the new engine. If he did not > ANALYZE TABLE for a myisam then EXPLAIN will give large row counts in > my experience. > > -- > Rob Wultsch > [EMAIL PROTECTED] > wultsch (aim) > -- Krishna Chandra Prajapati