Index Unused in query using DB Link

[abhaysk]

restructure your query..it will give results fast.

Select A.col1,A.col2,A.col4,A.col5, SUM(A.col6)
From 
(
Select t1.col1,t1.col2,t2.col4,t2.col5, t1.col6
From t1, t2
Where t1.col1 = t2.col1
And t1.col2 = t2.col2
And t1.col3 = t2.col3
And t1.col1 = 'XXX'
And t1.col7 = 123
) A
Group by A.col1,A.col2,A.col4,A.col5;

Abhay.