The MySQL manual http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#MySQL_indexes
states "All MySQL indexes (PRIMARY, UNIQUE, and INDEX) are stored in B-trees. Strings are automatically prefix- and end-space compressed.". Other RDBMSes out there state in the their respective manuals that if your table size (number of records) changes by more than N% (usually 5% i think) that it is a good idea to drop and re-create any indexes to help re-balance the potentially unbalanced B-tree. Is this true with MySQL too? Does 'myisamchk -S' take care of that? Also: Is this covered in the manual and I am just missing it? If not, can it be added? b. --------------------------------------------------------------------- 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
