[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=13099607#comment-13099607 ] 

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

> Van is correct, it still does not show the info we are after.

You'll need to be specific about what you want to see.

> its just that in other DBs you only have to add the word 'explain' before the query, and it will give you the plan.

Unfortunately there's no standard syntax nor plan form.  Ours was effectively derived from sql server, so it just depends upon what you are familiar with.

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