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

Why creation of temporary files depends on the value of MAX CORE

1 Answers   HCL,


What is the purpose of having stored procedures in a database?

0 Answers  


What are the different types of partition components in abinitio?

0 Answers  


Pdl with an example?

0 Answers  


What are the Types of parallelism in detail?

0 Answers  






List out the file extensions used in abinitio?

0 Answers  


Where $mpjret is used in ab-initio?

0 Answers  


How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have used In Memory Sort,so how will it work in terms of performence as compared with PBKand Sort Component?

1 Answers  


What is broadcasting and replicate?

0 Answers  


What does it mean by the term 'sort component'?

0 Answers  


How to add default rules in the transformer?

0 Answers  


Have you used the rollup component? Describe how?

0 Answers  






Categories