How can you see the dynamic query plan in Tibco Data Virtualization (TDV) that provides the statistics of the query execution?
book
Article ID: KB0079901
calendar_today
Updated On:
TIBCO Data Virtualization
|
-
|
Description
Dynamic query plan can be useful to determine at which stage of the query execution, the query takes the most time.
Issue/Introduction
This document shows how to see the dynamic query plan that provides the statistics of the query execution.
Resolution
Generate the query plan and then click at the bottom “Execute and Show Statistics” button.
Other method is to select the query plan from the Studio->Manager->Requests-> ‘Show Query Plan’
Feedback
thumb_up
Yes
thumb_down
No