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

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 8.5
    • Component/s: Query Engine
    • Labels:
      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  dsteigne Deborah Steigner
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: