Hans Zeller created TRAFODION-2618:
--------------------------------------
Summary: 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: David Wayne Birdsall
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)
