Oracle DBA Question:
Download Job Interview Questions and Answers PDF
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)
Download Oracle DBA Interview Questions And Answers
PDF
| 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. |