Hi Dan,
The contents of both tables is identically.
I checked both tables with SHOW INDEX FROM ...
and the cardinalities are exactly the same.
Nevertheless, thanks for mentioning that those numbers are estimates.
Regards, Cor
- Original Message -
From: Dan Buettner [EMAIL PROTECTED]
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
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