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
9332 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 Is_defined(), Is_null(), Is_Blank()?

1 Answers TCS,

What is use of creating a save files? How to use in abinitio graph?

1 Answers Cognizant, IBM, Intellego, TCL,

What dedup-component and replicate component does?

0 Answers

what is the relation between EME , GDE and Co-operating system ?

4 Answers

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

0 Answers HP,

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

0 Answers

What is abinitio?

0 Answers

How many components in your most complicated graph?

0 Answers

What is MAX CORE of a component?

0 Answers

What do you mean by the overflow errors?

0 Answers

What is the significance of ‘mp run’ command ?

1 Answers TCL,

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

5 Answers

For more Ab Initio Interview Questions Click Here