I have a MyISAM table with about 2 billion records and an index on 5 fields.
The insertion of records to this table is very slow, because of the time needed to create the index.
On the other hand i do not need this index while filling the table, only need it at a later time when i do searches.
So i inset records to the table without having the 5-field index and create it later.
My question is which is the fastest way to create this index ?
1. Using alter table ?
2. Dumping the records into a text file and loading them into a blank table with the correct indexes ?
3. There is some other way ?