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
9378 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 hash file in abinitio? how will it read in abinitio? in hash file the data files r combine (file1.dat,file2.dat,file3.dat......etc) how will it divide?

2 Answers HP,

What is the core of co> operating system?

0 Answers

explain checkin and checkout?

0 Answers

How will u remove header record? How will u remove tailer record?

5 Answers EDS, Polaris,

What do you mean by continuous graph? what is it significance?

1 Answers IBM,

Explain the difference between the truncate and delete commands?

0 Answers

How is the partitioning with key different from round robin partition?

0 Answers

Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?

0 Answers

If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.

2 Answers

What is standard environment ?

2 Answers

Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?

2 Answers

What is the importance of eme in abinitio?

0 Answers

For more Ab Initio Interview Questions Click Here