Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2249

Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 8.5
    • None
    • Query Engine
    • None

    Description

      Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead.

      One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server.

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-dsteigner Deborah Steigner (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: