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

[Van Halbert (JIRA)]

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

Van Halbert edited comment on TEIID-3637 at 8/18/15 3:36 PM:
-------------------------------------------------------------

In the database tool, if you execute:

SET NOEXEC ON

before you execute the sql, it won't execute, but will provide a query plan.

But it still doesn't provide the full info you're after.


was (Author: van.halbert):
In the database tool, if you execute:

SET NOEXEC ON

before you execute the sql, it won't execute, but will provide a query plan.

> 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)