Hi The indexes are updated when you insert data, you don't need to update it manually. However, you may want to find out about the 'optimize' function out of interest.
http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html Regards Girish ----- Original Message ----- From: "Chuck Lidderdale" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 6:19 PM Subject: update index ... > 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 > --------------------------------------------------------------------- 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