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

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 6.1.0
    • 6.0.0
    • Import/Export

      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.

              rhn-engineering-jdoyle John Doyle
              mwalker1@redhat.com Michael Walker (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: