Oracle High Performance Tuning for 9i and 10g

J

Joins in SQL, 161–72

anti joins, 171–72

cartesian products, 170

efficient joins, 165–66

equi joins and range joins, 168–69

inefficient joins, 169–70

intersections, 166–68

join formats, 161–65

mutable and complex joins, 172

outer joins, 170–71

self joins, 168

tuning, 172