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
9491 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

Describe the Evaluation of Parameters order.

1 Answers

how does deadlock occur?

6 Answers IBM,

Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...

1 Answers

What are the operations that support avoiding duplicate record?

0 Answers

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

0 Answers

what is the output when -1 is put in select_expr of FBE?

0 Answers

How does the bre work with the co>operating system?

0 Answers

Can you use scan to generate sequence number ? How to use in abinitio graph?

2 Answers IBM, TCL,

Can sorting and storing be done through single software or you need different for these approaches?

0 Answers

What are the benefits of data analyzing?

0 Answers

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

0 Answers

The methods to improve performance of a graph?

0 Answers

For more Ab Initio Interview Questions Click Here