[ https://issues.apache.org/jira/browse/TRAFODION-2618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller closed TRAFODION-2618. ---------------------------------- > 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 > Fix For: 2.2-incubating > > > 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)