How can you see the dynamic query plan in Tibco Data Virtualization (TDV) that provides the statistics of the query execution?

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:

Products Versions
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’