UDB 8.2

OS: AIX.



I am trying to find out the bad queries from dynamic SQL output.

How do i identify the badly running quries from the out put of dynamic sql.

How do i analyze from the following out whether it is badly executing ..or not..

umber of executions = 6
Number of compilations = 1
Worst preparation time (ms) = 98
Best preparation time (ms) = 98
Internal rows deleted = 0
Internal rows inserted = 0
Rows read = 2328
Internal rows updated = 0
Rows written = 0
Statement sorts = 18
Statement sort overflows = 0
Total sort time = 0
Buffer pool data logical reads = 192
Buffer pool data physical reads = 7
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Buffer pool index logical reads = 120
Buffer pool index physical reads = 42
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Total execution time (sec.ms) = 0.219802
Total user cpu time (sec.ms) = 0.000000
Total system cpu time (sec.ms) = 0.010000

Statement : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxx