Hi Every night. I dump the schema of a table, drop it, create the table, and load it up with data. I'm using phpMyAdmin for the most part. I notice that the index cardinality shows up as None in phpMyAdmin for each index I have. If I drop the index and re-create it, all of the indexes show their correct cardinality. I don't think phpMyAdmin is at fault because searching on the table before I fix it is sluggish until afterwards. Is the a command I could run that would re-index everything after I dump the data into the table? Or what is going on?
thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
