When somebody is saying sql query is slow. u can follow these steps.
Take the trace of the sql and verify the xplain plan.
Queries can be tuned by checking if there is better path to follow, like is it picking the good index or no index at all, some times it can be tuned by rewriting the query.