Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: after inserting do i have to reindex

    I'm using VB to insert the data, do i have to reindex.

  2. #2
    Join Date
    Oct 2003
    Denver, Colorado

    Re: after inserting do i have to reindex

    MySQL maintains the index of records inserted and updated. You don't have to rebuild the index every time you insert. If you suspect a bad index file, run CHECK TABLE <tablename> EXTENDED and all the keys in the table will be verified. This can take a long time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts