How might you quantitatively measure an improvement made to
a query?

Answer Posted / sbs

Check out the execution plan

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain the co>operating system’s processing model?

597


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

847


How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

606


What are the fundamental blocks of co> operating system of ab initio?

715


Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

635






Explain the ab initio etl tool in high level?

662


What is data mapping and data modelling?

960


The methods to improve performance of a graph?

631


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

604


What is MAX CORE of a component?

697


Explain what is the architecture of abinitio?

658


How to run a graph infinitely?

656


what is the project environment(for each project the environment is same or different to different project)?

1640


Have you ever encountered an error called “depth not equal”?

640


To which project that prefix will set is to private project or public project or both?how and where to set?

1388