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