I have a table with about 2-3 million records. I have created index on some of its column. But I need to add new records to it regularly. How can I re-index those index files?
Thanks in advance.
IndiaMaster
4:45 pm on Nov 1, 2008 (gmt 0)
The table type is InnoDB.
phranque
2:53 am on Nov 2, 2008 (gmt 0)
usually when you create an index on a table column the database also updates the index for that column whenever you add rows to the table.
