Common Issues to Be Aware of
Cartesian Product
Full Table Scan
Join Order
Nested Loops
Sort
Parent topic:
Analyzing the Explain Plan