How to export the execution plan of a query in TIBCO Data Virtualization?

How to export the execution plan of a query in TIBCO Data Virtualization?

book

Article ID: KB0072859

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

Queries can be run either in SQL Scratch Pad or in a TDV View. How to export the execution plan of a query in TIBCO Data Virtualization?


 

Issue/Introduction

How to export the execution plan of a query in TIBCO Data Virtualization?

Resolution

1. Launch TIBCO Data Virtualization Studio and open the view/ query of interest. 
2. Click on the 'Show Execution Plan' button (Second button on the top left corner of the window) 
3. Click on 'Export Plan' button (Second button on the top left corner execution plan dialog) 

Reference :
User-added image

Additional Information

https://support.tibco.com/s/article/How-do-I-obtain-an-execution-time-Query-Plan
https://support.tibco.com/s/article/How-to-generate-a-query-execution-plan-in-client-tools-connected-to-TIBCO-Data-Virtualization-through-JDBC-ODBC
Powered by Wolken Software