To optimize, you would need to see the query in context. You would need to baseline the performance and the execution plan, so that any amendments can be validated. Certainly we can offer different ways of writing the same query, but often the knowledge of how many rows are in tables, how do they relate, what does the data mean - all play a part.