dynamobi/dynamobi — Issue #118: [LDB-204] Rewrite count(*) from table with no filters/aggs/etc to use FEM storedtable values
Author: dynamobi-build
Created: 2011-12-30 02:14:38+00:00
State: open
Labels: LDB, Optimizer

[reporter="ngoodman", created="Mon, 30 Nov 2009 13:34:16 -0500 (GMT-05:00)"]
We have total counts for the entire table here:

select * from sys_boot.mgmt.dba_stored_tables_internal1

which use sys_fem.med."StoredTable"

It has actual row counts - we should be able to rewrite queries to this and have lightning fast:

select count(*) from table;