>The "warning: Found 22079089 parts Should be: 0 parts" is a >known error of myisamchk in MySQL 4.0.1, and is already fixed in MySQL 4.0.2
Thanks, Jocelyn, good to know, but the cardinality of the resulting indexes is STILL NULL: hence perhaps not fixed. So the bug report may yet remain... -steve mysql> use elenco2g Database changed mysql> show indexes from White; +-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+--------- + | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+--------- + | White | 0 | PRIMARY | 1 | rec_no | A | NULL | NULL | NULL | | | White | 1 | phone_no | 1 | phone_no | A | NULL | 8 | NULL | | | White | 1 | loc | 1 | city | A | NULL | 4 | NULL | | | White | 1 | loc | 2 | street_name | A | NULL | 2 | NULL | | | White | 1 | postal_code | 1 | postal_code | A | NULL | NULL | NULL | | | White | 1 | clf | 1 | city | A | NULL | 6 | NULL | | | White | 1 | clf | 2 | last_name | A | NULL | 6 | NULL | | | White | 1 | clf | 3 | first_name | A | NULL | 1 | NULL | | | White | 1 | plf | 1 | province | A | NULL | NULL | NULL | | | White | 1 | plf | 2 | last_name | A | NULL | 7 | NULL | | | White | 1 | plf | 3 | first_name | A | NULL | 2 | NULL | | | White | 1 | pref | 1 | prefix | A | NULL | NULL | NULL | | | White | 1 | pref | 2 | city | A | NULL | 1 | NULL | | +-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+--------- + 13 rows in set (0.07 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php