RE: cardinality in SHOW INDEX

2003-11-06 Thread Dathan Vance Pattishall
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

cardinality in SHOW INDEX

2003-11-06 Thread Hsiu-Hui Tseng
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