• Well, not being able to see the query and the execution plan, not much we can do.  There are things to look for, such as sub-queries with DISTINCT.  This could be valid, but it could also hide poor joins between tables.
    Another thing would be any mismatches in data types in in joins or where clauses.