Subject | RE: [ib-support] SELECT COUNT(*) ... - slow |
---|---|
Author | Tobias Giesen |
Post date | 2002-04-05T23:21:47Z |
> And the reason it doesn't, is that there may beSo what? It could maintain separate counters for each
> different numbers of rows for different concurrent
> transactions.
transaction, as well as a main counter for the committed
rows. I'm sure it could.
However, this optimization feature doesn't seem to have
been considered worth it.
Cheers,
Tobias