[jira] [Assigned] (TRAFODION-2618) SET ROWCOUNT option in UPDATE STATISTICS doesn't suppress rowcount logic

["Hans Zeller (JIRA)" <ji...@apache.org>]

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

Hans Zeller reassigned TRAFODION-2618:
--------------------------------------

    Assignee: Hans Zeller  (was: David Wayne Birdsall)

> SET ROWCOUNT option in UPDATE STATISTICS doesn't suppress rowcount logic
> ------------------------------------------------------------------------
>
>                 Key: TRAFODION-2618
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2618
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-cmp
>    Affects Versions: 2.0-incubating
>         Environment: Any
>            Reporter: Hans Zeller
>            Assignee: Hans Zeller
>
> There is an undocumented option in the update statistics command:
> update statistics ... sample ... set rowcount <num>
> This "set rowcount" option is meant to avoid the need to get an approximate rowcount of the table before reading a sample. However, it seems that update statistics still invokes at least some code to get a rowcount, even in the presence of this option.
> This issue is somewhat related to TRAFODION-2617. We tried the "set rowcount" option as a possible workaround for TRAFODION-2617 but still got the same error.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)