⟩ How would you find out whether a SQL query is using the indices you expect?
Explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.
Question and Answer:
Home Ab Initio
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What is surrogate key? where we use it explain with example?
What are the Data Marts?
Explain What are the vaious ETL tools in the Market?
Explain the definition of normalized and denormalized view and what are the differences between them?
How can we acheive Correlated sub-query in Designer?can anyone help me in this regard?
We want to restrict top 26 rows ... in report is there any rownum object from which we can do this?
What are steps we have to follow in designing the userfriendly Universe?
What is mean by aggregate aware? How we are using this function?
what are templates in which way it is help full? what is data provider? what is freehand sql? difference between b.o 5.1 and 6.1b?
Explain in Detail abt Measure Objects? and what is the use of it? How to create it?
