I have a question regaring indexes in MySQL.
When I insert data I have read that is good to turn them off
But is that still ok if I have records that already exists in the database that i'm going to insert agan.
I use the On Duplicate Insert so is it still ok then even if I turn the indexes off?
And how do I turn it off? do I need to do something more then turn it off and then on again. do I need to do any optimize,flush etc?