Thank you Selva,
Gunnar pointed me to the sql manual guide before. I should read it more
carefully.
There are a lot of information in your reply, I need some time to understand
all of them. But for my major question mark ‘how to tell running time in
different part for a given query’ is
Hi Ming,
The counters or metrics returned by RMS in Trafodion are documented at
http://trafodion.apache.org/docs/2.0.0/sql_reference/index.html#sql_runtime_statistics
.
Counters displayed in operator stats:
The DOP(Degree of Parallelism> determines the number of ESPs involved in
executing
Hi, all,
We have running some complex queries using Trafodion, and need to analyze the
performance. One question is, if we want to know which part of the plan take
longest time, is there any good tool/skills to answer this?
I can use 'get statistics for qid default' to get runtime stats. But