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) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]