Whats best way to have indexing in mysql : Need a support! Seems like small question, but i am puzzled. 

I have a table with around 25 columns. The table will contains many lakhs of rows at any point of time. 
I want to run below query continously in loop.

    SELECT recordfile
    FROM MYTABLE 
    WHERE duration = '0'
    AND attempt < max_attempt
    AND thread =1
    ORDER BY id ASC 

It looks like query is taking more time(0.0150 secs on avg) Please help to put proper indexing or any other method, to make the query optimally quick.

Thanks!