Did the create table several months ago. Did a create index idx_abc on tableA...... Have added lots of data - lots of data .....
Back when I worked with Informix I would run "update statistics for tableA ...." which would recreate the index - et-al. Now I'm using Mysql - do I need to do anything like that now? Or do I have to "drop index idx_abc ... and create index abc all over? Or doesn't it matter? Tks Chuck --------------------------------------------------------------------- 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
