dynamobi/dynamobi — Issue #121: [LDB-201] Rewrite count(*) to count(smallest idxed column) if idx only scans enabled
Author: dynamobi-build
Created: 2011-12-30 02:14:46+00:00
State: open
Labels: LDB, Optimizer

[reporter="ngoodman", created="Sat, 24 Oct 2009 16:07:04 -0500 (GMT-05:00)"]
Add an optimizer rule to:

if ( idx only counts enabled)

rewrite count(*) to count (<>)

else

keep count(*) as is