Hi, After rebuild the following table, the Cardinality does not get updated. This table have 18 million of rows. Why this happening and how do I fix it? Should I run OPTIMIZE TABLE or CHECK TABLE?
mysql> show index from UserDetail; +------------+------------+--------------------+--------------+------------- -------+-----------+-------------+----------+--------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +------------+------------+--------------------+--------------+------------- -------+-----------+-------------+----------+--------+---------+ | UserDetail | 0 | PRIMARY | 1 | UserID | A | NULL | NULL | NULL | | | UserDetail | 0 | PRIMARY | 2 | PartnerAttributeID | A | 18936654 | NULL | NULL | | | UserDetail | 1 | IDX_AttributeValue | 1 | PartnerAttributeID | A | NULL | NULL | NULL | | | UserDetail | 1 | IDX_AttributeValue | 2 | AttributeValue | A | NULL | NULL | NULL | | +------------+------------+--------------------+--------------+------------- -------+-----------+-------------+----------+--------+---------+ thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
