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

Answers were Sorted based on User's Feedback



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

Answer / sbs

Check out the execution plan

Is This Answer Correct ?    2 Yes 0 No

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

Answer / 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

More Ab Initio Interview Questions

What is the diff between abinitiorc and .abinitiorc files ?

1 Answers   TCL,


We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

0 Answers  


Can you explain the co>operating system’s processing model?

0 Answers  


In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?

1 Answers   IBM, TCL,


What do you mean by a transaction file?

0 Answers  






Can we specify checkpoints without Phases?

3 Answers   IBM, Tech Mahindra,


How to Create Surrogate Key using Ab Initio?

6 Answers   IBM,


What are the Graph parameter?

0 Answers  


You can ask about - meta pivot, leading records, read & write multiple files component ? How to use in abinitio graph?

1 Answers   IBM, TCL,


Explain about ab initio’s dependency analysis?

0 Answers  


What are the different types of partition components in abinitio?

0 Answers  


How you can run a component for certain conditions ?

1 Answers  






Categories