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

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

Question Posted / guest

2 Answers
9383 Views
I also Faced
E-Mail Answers

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 difference between a scan component and a rollup component?

0 Answers

Can anyone give me an example of realtime start script in the graph?

0 Answers

what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.

1 Answers IBM,

what does layout means in terms of Ab Initio?

3 Answers

Describe the evaluation of parameters order in ab initio?

0 Answers

What is the difference between Generate Records Component and Create Data Component?

6 Answers Steria,

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

0 Answers

What is a data processing cycle and what is its significance?

0 Answers

How to connect mainframe to Abinitio?

1 Answers CTS,

To which project that prefix will set is to private project or public project or both?how and where to set?

0 Answers

) How can you count the total no .of records in the specified partition in the Multifile?

5 Answers

How can you connect eme to abinitio server?

1 Answers

For more Ab Initio Interview Questions Click Here