I have a fairly large database on my (2 million records)
WIN32 mySQL 4.0.20
The question is:
I am adding large amounts of data to it (300,000 to 500,000 at a time) with
the standard (INSERT INTO) command.
Question is, do I have to reindex, and when and how often?
Does mySQL automatically build indexes on the fly as I add data?
If I do have to reindex, is there a command that will rebuild all the
indexes for that table (I have 4) ???
Thanks for ANY clarification.
Craig
cs********@hotmail.com