var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Dynamic Sql Snapshot
I have taken a snapshot of dynamic sql being run on a DB2 Database version 8 fixpack 3 on Windows 2000 Machine.
The snapshot is like this
Number of executions = 35
Number of compilations = 0
Worst preparation time (ms) = 2
Best preparation time (ms) = 2
Internal rows deleted = 0
Internal rows inserted = 0
Rows read = 3035760
Internal rows updated = 0
Rows written = 0
Statement sorts = 70
Total execution time (sec.ms) = 21.033072
Total user cpu time (sec.ms) = 11.750000
Total system cpu time (sec.ms) = 9.234375
Statement text = Select name from employee.
I cannot infer the following
1. The total execution time for a single query is 21 seconds.
2. The total execution for executing the query 35 times is 21 seconds.
Can anyone please explain the relation between Number ot Executions and Total Execution Time.
I am confused.
Thanks in advance
the total execution time that you see is the total time taken for total number of executions. So, in order to get exec time for one execution, you need to divide Total Execution time by number of executions and ofcourse, you will get an average value.
hope this answers your question..
My confusion is cleared.