Hello,
It sounds you need to optimize your database.I am working with databases since 5 years and have a lot of expertise.I can optimize your database by taking following measures:
1- physicalize the tables
2 - stats collection
3 - creating primary and secondary indexes
4 - creating aggregated join index if required