How might you quantitatively measure an improvement made to
a query?
Answer Posted / 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 View All Answers
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
Can anyone give me an exaple of realtime start script in the graph?
How to compare two dmls in abinitio
What is the difference between sandbox and EME?
What are the benefits of data analyzing?
What are the six data process products of ab initio (architecture of ab initio)?
Explain how abinitio eme is segregated?
When we should use 'jobid' for commit table (Output table component??
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
How to add default rules in the transformer?
What is de-partition in abinitio?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
Within a cursor, how would you update fields on the row just fetched?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?