Statistic Gathering Approaches – Column boundary vs. Table Boundary
Article ID: KB0080369
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
Statistic Gathering Approaches – Column boundary vs. Table Boundary
The configuration and usage of cardinality statistics is described in "Creating Cardinality Statistics for Cost-Based Optimization" section of Tibco Data Virtualization User Guide. Refer to the topic on Creating Cardinality Statistics on a View, for information on how this panel is configured and used.
The configuration and usage of cardinality statistics is described in "Creating Cardinality Statistics for Cost-Based Optimization" section of Tibco Data Virtualization User Guide. Refer to the topic on Creating Cardinality Statistics on a View, for information on how this panel is configured and used.
Issue/Introduction
Statistic Gathering Approaches – Column boundary vs. Table Boundary
Resolution
|
Approach
|
Computation
|
Effort to infer information
|
|
Column Boundary
|
High
|
It builds histograms for each column. So it’s very detailed and granular but takes the most effort to infer the information as well.
|
|
Table Boundary
|
Least
|
It returns the number of total rows and distinct rows per table. Very easy and most direct.
|
- Table boundary approach is the most recommended for large tables, It lets you the save computation effort for large data sets and the results are direct and easy to comprehend.
- Recommended time to collect statistics is off-peak hours.
Feedback
Yes
No
Powered by
