You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2017/05/18 20:17:04 UTC
[jira] [Work started] (TRAFODION-2618) SET ROWCOUNT option in
UPDATE STATISTICS doesn't suppress rowcount logic
[ https://issues.apache.org/jira/browse/TRAFODION-2618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on TRAFODION-2618 started by Hans Zeller.
----------------------------------------------
> 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)