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

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?..

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

More Ab Initio Interview Questions

What is the Reformat Layout?(i/p ->Reformat->o/p)

Explain the methods to improve the performance of a graph?

What is meant by Co > Operating system and why it is special for Ab-initio ?

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

How data is processed and what are the fundamentals of this approach?

What will be the skew for, input file->partition by key-> partition by round robin->output file

explain checkin and checkout?

Describe which system or process elements you would review when trouble-shooting general server slows ?

In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?

I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?

What are differences between different versions of co-op?

List the various vector functions used in ab initio with syntax.

For more Ab Initio Interview Questions Click Here