#1 Benchmarked queries all contain count

[Frank Schlottmann-Goedde]

count is an extremely expensive operation for a
multigenerational database.

To get a fair comparison between several database
architectures you should add some more queries
(avoiding count) :-)

[Mark Kirkwood]

Logged In: YES
user_id=630732

More variety of aggregate types would be an advantage (MAX,
MIN, SUM ...) , as would more complex join types and
LIMIT/ROWNUM type
operands. To want more variety is fair enough :-)

To want to remove count is not, as it is a very commonly
desired aggregate in data warhousing. So if this is
difficult for multi generational databases - then, er, well,
good - something for the generational boys to work on :-)