Subject Re: [firebird-support] Why does DISTINCT does not use the index in this simple case?
Author Marc Bettex

The times that I gave in my previous post are the times that are required to get the first 25 or so records. Sorry about the ambiguity.

And yes, you are right to assume that the records are stored in Id order.

Thanks a lot for your detailed answer. I think that I understand a bit better how things works now.