Robert martin wrote:

>
> I never realised how many other DBs were implementing an MGA
> architecture. One of FBs weaknesses has been with Select Count()...
> statements. It has always been blamed on the fact that FB is MGA and
> 'Other' faster DB is not. If the others are MGA as well is the select
> Count() really a FB issue NOT and MGA issue?
>

PostgreSQL explains from time to time that their select count is
slow because of MGA. Oracle's implementation is so different that
there's no basis for comparison. Really slow counts are caused by
a problem with garbage collecting long strings of index duplicates.
Version 2 has a new index structure that corrects that problem.

Regards,


Ann