Brilliant! Without indexes, 200K rows in 7 hours. With indexes, 2.6million rows in 35 minutes!!! :w00t:

First create the indexes as advised (allow around 10 minutes to complete):

CREATE

INDEX...