You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/08 00:58:26 UTC

[jira] [Updated] (TRAFODION-25) Insert, delete and update operators should use specialized cost method

     [ https://issues.apache.org/jira/browse/TRAFODION-25?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah updated TRAFODION-25:
------------------------------------
    Component/s: sql-cmp

> Insert, delete and update operators should use specialized cost method 
> -----------------------------------------------------------------------
>
>                 Key: TRAFODION-25
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-25
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>            Reporter: Qifan Chen
>            Assignee: David Wayne Birdsall
>              Labels: performance
>
> In Trafodion, insert, delete and update operators do not use a specialized cost method that model the true operation involved. 
> As a result, these operators can be assigned a zero cost and the query plan may not be optimal. In one example, a delete query against a partitioned table may get a serial plan. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)