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

Details

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

    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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: