Uh oh, another developer doing a DBA's job.
Gotta go clean my gun collection.

When was the last time the tables was analyzed?
Can you view the indexes and try to code accordingly?
Do you think any performance type indexes would help?
When was the last time you bought your DBA lunch?