-
1. Re: Understanding teiid Query Plan
shawkins Dec 4, 2017 12:37 PM (in response to varun09)Getting the query plan at the end of execution will show the various node timings - have you seen Query Plans · Teiid Documentation ?
The root node will contain Node Cumulative Process Time and other stats that may be of interest.
Node Cumulative Process Time
-
2. Re: Understanding teiid Query Plan
varun09 Dec 5, 2017 2:25 AM (in response to shawkins)Hie Steven,
Thanks for the answer !!!
I have gone through the query plan documentation and also generated a query plan for my query.
However in my query plan I did not get a root node, but I got the below nodes;
ProjectNode
GroupingNode
JoinNode
UnionAllNode
Access Node
Can you help me understand as to why I am not able to get the root node in my query plan ?
-Varun
-
3. Re: Understanding teiid Query Plan
shawkins Dec 5, 2017 9:04 AM (in response to varun09)> Can you help me understand as to why I am not able to get the root node in my query plan ?
The root node is not a type of node, but the first one / top of the plan. That contains the overall timings for the plan.