⟩ Explain two easy SQL optimizations.
a. EXISTS can be better than IN under various conditions
b. UNION ALL is faster than UNION (not sorting)
Question and Answer:
Home Oracle DBA
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
How can we use mapping variables in Informatica? Where do we use them?
What is a mapping, session, worklet, workflow, mapplet?
What is Informatica Metadata and where is it stored?
How do we call shell scripts from informatica?
Can Informatica load heterogeneous targets from heterogeneous sources?
What are the different Lookup methods used in Informatica?
What are active transformation / Passive transformations?
What are the modules in Power Mart?
Compare ETL & Manual development?
When do we Analyze the tables? How do we do it?
