fast retrieval of millions of record

[Akasmika Dash]

Dear All,

I'm working for the summary log which will generate a log file from MySQL database.
For putting into file I've written SELECT * ..... INTO OUTFILE appp.csv FROM ...

For summary log, I've to do a JOIN from 8 tables.

I've made proper indices in the tables.

Now for some 4 lakhs records, it's taking 1 minute. I want to make it faster as it will be placed in real network.

Can I make the log creation faster as I have to deal with millions of recors.

Thanks in advance.

Regards
Akasmika