Tuning Query or Table ?

 I have a table with rows name, name2, distance. I need to be able to select all the rows with name = var1 or name2 = var1 against 945 Million rows.  My current solution takes about 1 second. The problem is,  I have to perform this query about 1.8 Million times. And the problem is presented ..... :-)  Is there anyway to speed this up with indexes or whatever.  Currently i have indexes on name, name2, and name and name2.

This is Oracle 11gR2 on Windows 2008 Server.

Thanks.

Jeff