[teiid-issues] [JBoss JIRA] (TEIID-5740) Add support for EXPLAIN

[Steven Hawkins (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13806995#comment-13806995 ] 

Steven Hawkins commented on TEIID-5740:
---------------------------------------

There really isn't an immediate visual aspect.  This is the same plan form you can get over JDBC (either via the old jdbc extension, or with with SET SHOWPLAN etc.).  The difference is for pg clients.  It's superficially the same syntax as pg and the implementation details of the other methods (only available over jdbc or dependent on the last executed statement, which due to metadata queries may not be the user query) you couldn't really get the query plan from the client.

> Add support for EXPLAIN
> -----------------------
>
>                 Key: TEIID-5740
>                 URL: https://issues.jboss.org/browse/TEIID-5740
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 13.0
>
>
> We need another mechanism for viewing plans - either a procedure or a table.  We also have a lot of vdb information that is not exposed via system metadata.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)