[JBoss JIRA] (TEIID-3009) perform projection minimization on with commands
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3009?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3009:
----------------------------------
Fix Version/s: 8.9
(was: 8.8)
Pushing to 8.9 as this is larger than should go into 8.8 post CR1.
> perform projection minimization on with commands
> ------------------------------------------------
>
> Key: TEIID-3009
> URL: https://issues.jboss.org/browse/TEIID-3009
> Project: Teiid
> Issue Type: Sub-task
> Security Level: Public(Everyone can see)
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> We currently treat the with clause as the creation of a temporary table at a query scope, but we can do projection minimization based upon the referenced columns. This is somewhat tricky with the current planning logic as we must first plan the with clause to determine if it's eligible for pushdown to then plan the main command.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months
[JBoss JIRA] (TEIID-3019) Change SYSADMIN.refreshMatViewRow to support a list of rows instead of just one
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3019?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3019:
----------------------------------
Fix Version/s: 8.9
Tentatively slating for 8.9. For this to have much of a performance benefit it will also require new global table store / event distributor methods (we currently only have the single row methods). Or if we don't quite want to go that far, then we can add just a new top level procedure and address the internals later.
> Change SYSADMIN.refreshMatViewRow to support a list of rows instead of just one
> -------------------------------------------------------------------------------
>
> Key: TEIID-3019
> URL: https://issues.jboss.org/browse/TEIID-3019
> Project: Teiid
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Server
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> Currently SYSADMIN.refreshMatViewRow supports only passing one key value so it will be nice to be able to pass multiple values or array of values for bulk updates.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months