How to destroy "cardinality statistics" for a resource in TIBCO Data Virtualization?
Article ID: KB0075447
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.6 and higher |
Description
The TDV SQL Query Engine has an option to use statistics gathered from the data sources, when they are available, to create an efficient SQL query execution plan for joins or unions across tables, or to optimize caching. Statistics gathered on tables or views provide the SQL Query Engine with estimates on the table cardinality (the number of unique values or rows) so that optimizations can be applied.
Gathering data source statistics, can be a long process that can use significant amount of resources. In some cases gathering cardinality statistics may have effect on performance of TDV Server. In such cases, it is recommended to destroy the "cardinality statistics" for a datasource in TDV.
Gathering data source statistics, can be a long process that can use significant amount of resources. In some cases gathering cardinality statistics may have effect on performance of TDV Server. In such cases, it is recommended to destroy the "cardinality statistics" for a datasource in TDV.
Environment
Windows.
Resolution
Follow the below steps to destroy "cardinality statistics" for a resource in TDV Studio :
(1) Launch TDV Studio.
(2) Open resource and select the "Cardinality Statistics" tab at the bottom.
(3) Click on 'Destroy Statistics" button on top right corner.
(4) Save the changes.
(1) Launch TDV Studio.
(2) Open resource and select the "Cardinality Statistics" tab at the bottom.
(3) Click on 'Destroy Statistics" button on top right corner.
(4) Save the changes.
Issue/Introduction
How to destroy "cardinality statistics" for a resource in TIBCO Data Virtualization?
Feedback
Yes
No
Powered by
