How might you quantitatively measure an improvement made to
a query?

Answer Posted / deepu

Check the run time of the query using the log and also the CPU usage of the query.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a deadlock and how it occurs?

671


Mention what is the syntax for m_dump in abinitio?

975


What does edp stand for?

736


What is a rollup component?

633


What are the operations that support avoiding duplicate record?

932






What are the types of data processing you are familiar with?

706


What parallelisms does Abinitio support?

732


Explain how you can run a graph infinitely in ab initio?

680


Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

605


How co>operating system integrates with legacy codes?

617


What exactly do you know about the typical data analysis?

600


What are “business rules” in ab initio business rules environment (bre)?

1429


When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

1918


Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

631


What is data encoding?

744