If your join condition matches with the index fields the query will also performs faster.

It is not the index that imporve the performance. You should look out at defragmentation aslo. If the fragmentation is at the highest level the query also improves.