[teiid-issues] [JBoss JIRA] (TEIID-3637) Query Plan/Execution Plan Enhancements

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3637:
---------------------------------------

> This should be presented in gui form for a better user experience as not many ppl would have access to the actual logs on the server.

It should be accessible from the tooling.  But it's currently just presented as a text file.

>  In addition to the gui any sql client should also display more detailed information doing something like "explain salect a from b", so that sql developers can debug their code.

See https://docs.jboss.org/author/display/TEIID/Query+Plans and "showplan debug"

What is likely needed is direction in the UI as to what needs to be shown out of both the debug and final plan forms.  From there we can look at providing a condensed form to the UI that's amenable for graphical display.

> Query Plan/Execution Plan Enhancements
> --------------------------------------
>
>                 Key: TEIID-3637
>                 URL: https://issues.jboss.org/browse/TEIID-3637
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>    Affects Versions: 8.7.1
>         Environment: RHEL 6, AWS VM, JBoss EAP (standalone)	6.3.2.GA	
> JBoss Data Virtualization	6.1.0.ER4
>            Reporter: Jorge Herrera
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> Query Plan / Execution plan, for any particular query is lacking more explicit information about what the query engine is doing for each query. Would like to know if its JDV doing the processing vs doing push down optimization, and what is the path it takes if its internal to JDV, and also the costs associated with every step.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)