query tuning

See more:

MySQL

I have a query which is like this:

SELECT distinct 
A.col1,
A.col2,
B.col3,
B.col4,
C.col5,
Left(C.col5, 8) AS GLAccount,
D.col6,
E.col7,
D.col8 as LineItemTotal
FROM dbo.TABLE1 A LEFT OUTER JOIN dbo.TABLE2 B
ON A.col1=B.col1
LEFT OUTER JOIN dbo.TABLE3 C
ON A.col1 = C.col1 LEFT OUTER JOIN TABLE4 D
ON B.col2 = D.col2 LEFT OUTER JOIN TABLE5 E
ON D.col3=E.col3
ORDER BY A.col2 ASC

This retrives appx aabout 60 lakh rows...and takes about 7 mins....I have to optimize it, I tried taking half of them into the view and then using the view, but that could only bring down the execution time to 3 and a half mins.....could someone please give me a solution for this?