Oracle DBA Question:
Download Questions 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)

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
How do you use automatic PGA memory management with Oracle 9i and above?Name three SQL operations that perform a SORT.