[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1618) Support partition statistics
[
https://issues.jboss.org/browse/TEIIDDES-1618?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-1618:
------------------------------------------
Could the use of multi-source models be also used for modeling
partitions?
Not as the feature currently exists.
With changes to the translator such that an override could be
provided that indicated to get the stats based on the partition.
What you are looking at here is more of the translator importing the partitions as tables
and then creating a view with a union.
The only other approach is to add in a higher level notion of partitioning such that the
partitioning scheme and stats could be associated with a source table.
Support partition statistics
----------------------------
Key: TEIIDDES-1618
URL: https://issues.jboss.org/browse/TEIIDDES-1618
Project: Teiid Designer
Issue Type: Feature Request
Reporter: Van Halbert
Assignee: Barry LaFond
The stats gathering feature does not take into account of partition statistics. Most of
our query hit a single partition and using the global stats is not a true indication of
the statistics for the single partition. It would be nice if Teiid engine can
differentiate the usage of global and partition statistics during the optimisation and
planning stages.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)