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
What would be the next step after collecting the data?
What is air-project parameter ?
When we should use 'jobid' for commit table (Output table component??
What is the syntax for m_dump in abinitio?
Why might you create a stored procedure with the with recompile option?
What is common among data validity and data integrity?
what is the output when -1 is put in select_expr of FBE?
What are the different types of parallelism used in abinitio?
Mention what is a partition and what are the different types of partition components in abinitio?
How would you find out whether a sql query is using the indices you expect?
Why might the optimizer use a table scan when an index is available?
What are the different forms of output that can be obtained after processing of data?
What are the differences between informatica and abinitio?
What is the difference between check point and phase?
What do you mean by a transaction file?