[teiid-issues] [JBoss JIRA] (TEIID-4558) Query Plan Analyzer

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins reassigned TEIID-4558:
-------------------------------------

    Assignee:     (was: Steven Hawkins)


I'm leaving this unassigned/unbucketed for now.  Our xml plan is only intended for consumption by tooling and contains a lot of information that could be presented in a different way that would highlight potential issues (which node consumed the most time, produced the most rows, etc.).  

Our text form of the plan could be improved or have an alternative display to be more compact.  [~kylin] had looked at that a little.  I would tie any effort like this to that - make the text plan easier to read and possibly annotate things like missing cardinalities, the longest running node, etc.

> Query Plan Analyzer
> -------------------
>
>                 Key: TEIID-4558
>                 URL: https://issues.jboss.org/browse/TEIID-4558
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Tools
>    Affects Versions: 9.2
>            Reporter: Van Halbert
>
> Provide a tool that would take a query plan and provide feed back.
> Example:
> -  indicate where there maybe a problem in the structure of the query that may impact performance
> -  indicate in the plan where there maybe issues (like table scan, no rows, etc.) 
> -  provide recommendations for improving performance
> etc..



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)