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

Reply via email to