⟩ Explain some disadvantages of the Indexes?
Indexes improve query performance but it slows down data modification operations.
Indexes consume disk space.
Question and Answer:
Home Oracle Database Optimization
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Do we need an ETL tool? When do we go for the tools in the market?
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
What are parameter files? Where do we use them?
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?
