Oracle DBA Question:
Explain two easy SQL optimizations.
Answer:
a. EXISTS can be better than IN under various conditions
b. UNION ALL is faster than UNION (not sorting)
b. UNION ALL is faster than UNION (not sorting)
| Previous Question | Next Question |
| How do you use automatic PGA memory management with Oracle 9i and above? | Name three SQL operations that perform a SORT. |