In my database, I have more than 30 million data in one field of table. Need to upgrade the table.
If I plan to do "SELECT INTO...", also I will add index in the special field, how could I get speed up using mysql command or other approaches?
When I tried to add index in the field, it seemed to take me forever, if I want to select into ..., it will take more time.
Any suggestions will be appreciate.
