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

[Steven Hawkins (Jira)]

    [ https://issues.redhat.com/browse/TEIID-4558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13998923#comment-13998923 ] 

Steven Hawkins commented on TEIID-4558:
---------------------------------------

To recap, there are a couple of things touched on here:

* static analysis of a query plan, which would indicate things like table access without predicates, cross joins etc.  -- all of that information is in the simple plan.  Additionally you could scan the debug log for annotations related to pushdown to highlight what predicates aren't pushed and why.

* analysis of a plan after it's been run, which looks more like a profiling tool to indicate what is the slowest part of the plan, etc.  This information as well is currently all in the simple plan.

Either way this really becomes about the user experience of consuming existing information, so I'm moving this over to Teiid Tools.

> Query Plan Analyzer
> -------------------
>
>                 Key: TEIID-4558
>                 URL: https://issues.redhat.com/browse/TEIID-4558
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Tools
>            Reporter: Van Halbert
>            Priority: Major
>
> 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.13.8#713008)