[ https://issues.apache.org/jira/browse/TRAFODION-3137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16540622#comment-16540622 ]
Anoop Sharma commented on TRAFODION-3137: ----------------------------------------- Does update stats always keeps the exact count or can it be approx at times? How will it be determined that a table has not been updated (ins/upd/del) after upd stats was done and before count(*) is executed? Will that check happen at every execute of a count? Is this a special row count statement or the regular count(*) stmt? Can a select from histogram table joined with MD objects table be used to get the count? > speed up count(*) by read row count from stats in special use cases > ------------------------------------------------------------------- > > Key: TRAFODION-3137 > URL: https://issues.apache.org/jira/browse/TRAFODION-3137 > Project: Apache Trafodion > Issue Type: Improvement > Reporter: liu ming > Assignee: liu ming > Priority: Major > > If the table is bulkload once and no change, and finish update statistics. > When doing count(*), there is no need to scan the whole table, but to read > row count from stats -- This message was sent by Atlassian JIRA (v7.6.3#76005)