Query optimalisation

I have running the query that you give me.