I first create a TEMPORARY TABLE.
Then I use LOAD DATA INFILE to load the file into the TEMPORARY TABLE I just created.
I'll then perform SELECT queries on that TEMPORARY TABLE.
I was wondering if I can't create a temporary INDEX in increase the query performance?
If yes, how do I do this?