[
https://issues.redhat.com/browse/TEIID-4558?page=com.atlassian.jira.plugi...
]
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)