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

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

How can you view the data in the Multifile

In abinitio, what types of parallelism are used?

Within a cursor, how would you update fields on the row just fetched?

What is m_dump?

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

Describe the Evaluation of Parameters order.

What do you know about partition and also tell us about partition components in abinitio?

What is the DynamicScriptGeneration and what is the Use?

Have you used rollup component? Describe how.

EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer

What are the primary keys and foreign keys?

For more Ab Initio Interview Questions Click Here