One of the best things you can do is run an explain plan on the query. It will tell your where you need to tweek.