With your conditions set against TABLE1 you will get about 9% (857747/9746801) of te rows returned. This means that an index would probably not be of any help.

Have you tried to execute your query in parallel?
Also please show explain plan of teh parallel query using DBMS_XPLAN.DISPLAY
http://download-west.oracle.com/docs...12/d_xplan.htm