Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. 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

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 6.0.0
    • Fix Version/s: 6.1.0
    • Component/s: Import/Export
    • Labels:
    • Environment:

      SFDC connector tech preview, windows 2003 server, MMX 5.5

      Description

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jdoyle John Doyle
                Reporter:
                michael.walker Michael Walker
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: