Optimizing SQL

A simple join optimizes SQL more effectively than issuing two related SQL statements separately.

However, if your transaction requires a complex SQL statement (for instance, one that uses correlated subqueries), consider breaking it up into multiple SQL statements. You may get more predictable performance this way.