Use analyze table to calculate cardinality. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED] -->Sent: Thursday, November 06, 2003 4:46 PM -->To: [EMAIL PROTECTED] -->Subject: cardinality in SHOW INDEX --> -->Hi, --> -->Some time I saw cardinality in SHOW INDEX is null. Why this happening? -->Then, -->I did a OPTIMIZE TABLE on the table and the number was getting back. --> -->We are going to switch all of our table to innodb. Will innodb has this -->problem? If it happend, how to fix it in innodb. Using OPTIMIZE TABLE? Is -->innodb support OPTIMIZE TABLE? --> -->Thanks! --> -->Hsiu-Hui --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]