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)

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