Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1255

Execution plan without executing the query

    XMLWordPrintable

    Details

      Description

      DTP execution panel, when user right clicks on the query and ask for execution plan then no execution plan is returned. Only if the user executes the query then the execution plan, then user requests for plan it is returned. A query plan can be retrived by excuting

      SET NOEXEC ON
      <query>
      SET NOEXEC OFF

      Also, when I tried to manually do the above steps in the DTP SQL Scrap Book, then it seemed like it is using a separate connection for each of the abouve commands. so to check that we did

      SET NOEXEC OFF

      SHOW NOEXEC -> result was -> NULL (should have been ON)

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  mdrillin Mark Drilling
                  Reporter:
                  rareddy Ramesh Reddy
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: