How to generate a query execution plan in client tools connected to TIBCO Data Virtualization through JDBC/ODBC?
Article ID: KB0075763
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
This article explains the process of generating a query execution plan for the views coming from TIBCO Data Virtualization in client applications. These client applications could be connected to TDV through JDBC or ODBC.
Environment
All supported operating system
Resolution
Execute the below query from the SQL editor of the client application:
The result for the above query will be returned in a column. The result obtained matches with the query execution plan generated through the TDV Studio.
explain select {option show_source_plan="true"} * from <view>;
The result for the above query will be returned in a column. The result obtained matches with the query execution plan generated through the TDV Studio.
Issue/Introduction
How to generate query execution plan in client tools connected through JDBC/ODBC with TIBCO Data Virtualization?
Additional Information
Reference from 'Views and Table Resources' of TDV User Guide:
https://docs.tibco.com/pub/tdv/8.2.0/doc/pdf/TIB_tdv_8.2.0_UsersGuide.pdf?id=13
https://docs.tibco.com/pub/tdv/8.2.0/doc/pdf/TIB_tdv_8.2.0_UsersGuide.pdf?id=13
Feedback
Yes
No
Powered by
