[teiid-designer-issues] [JBoss JIRA] Resolved: (TEIIDDES-182) Salesforce Importer should retrieve the Distinct Value Count for each column when creating the models, in order to improve cost-based query optimization

Salesforce Importer should retrieve the Distinct Value Count for each column when creating the models, in order to improve cost-based query optimization -------------------------------------------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-182 URL: https://jira.jboss.org/jira/browse/TEIIDDES-182 Project: Teiid Designer Issue Type: Feature Request Components: Import/Export Affects Versions: 6.0.0 Environment: SFDC connector tech preview, windows 2003 server, MMX 5.5 Reporter: Michael Walker Assignee: John Doyle Fix For: 6.1.0 The importer brings in table cardinality, but for even better query optimization, we should also bring in distinct value count, or provide an option to do so. This may be a larger one-time cost during import, but it's well worth it, and definitely is faster than doing it by hand for every column in every object in SFDC. It greatly impacts performance, especially for dependent join scenarios, since many SFDC columns/fields happen to have very low distinct value counts.