Thanks,
PeteLeft and right outer joins do different things. Whether the Sql is running the correct logic for the situation is what is most important. It's certainly possible that the query performance could be enhanced, particularly once multiple joins are involved but that is secondary do whether the queries are returning what is required.
I would try to understand what each query is trying to do and based on that think about alternatives that may simpify it and/or improve performance.sql
No comments:
Post a Comment