Chapter 7
Subqueries versus Joins
The purpose of this chapter is to demonstrate how you can use subqueries as alternatives to joins. There are two main issues to consider in choosing between subqueries and joins (and/or other techniques as well):
You must consider how you get information, which is often subjective. By understanding the limitations of joins and subqueries (and sets and other techniques, for that matter), you will broaden your choices as to how to get information from a database.
You must consider performance. You usually have choices ...
Get Practical Guide to using SQL in Oracle now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
