AIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, June 30, 2006 4:36 PM
Subject: Re: number of rows in EXPLAIN for unpacked vs packed tables
Cor -
Those numbers are an estimate, not a hard number, of how many rows
MySQL thinks it will have to exmaine
Cor -
Those numbers are an estimate, not a hard number, of how many rows
MySQL thinks it will have to exmaine to find what you're looking for.
They could be different because your compressed table is brand-new and
all the indexes are clean and up to date, whereas your original table
has possibly
Hi All,
I compressed a MyISAM table successfully with MYISAMPACK, followed by MYISAMCHK.
Both tables (MyISAM + Compressed ) have exactly the same number of rows with
Count(*).
But when I give a SELECT query with EXPLAIN on both tables, I get different
number of rows.
For example: EXPLAIN SELECT
