Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1474 Add a limit to the number of concurrent source queries issued.
  3. TEIID-2356

Add a query hint to limit the number of concurrent source queries

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Obsolete
    • Minor
    • None
    • 7.4
    • Query Engine
    • None

    Description

      We would like a new query hint to limit the number of parallel executions of union members. This is useful in two situations:
      1. When the queries are expensive, but the overall union contains a limit that is most likely to be fulfilled by the first member of the union
      2. When the queries are backed by a common resource which may be overloaded by multiple queries

      The addition of a hint would make this manageable by the client; perhaps something like "/+ parallel=2/"?

      Attachments

        Issue Links

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: