Subject Re: [firebird-support] How to implement sequential IDs with no missing vals?
Author Ann W. Harrison
Bambang P wrote:
>
>>The "select max(id) from ..." solution has a couple of problems.
>>First, it's really really slow,...
>
> Is it still slow if we have descending index of id on the table?
>

No, the index takes care of the performance problem, but leaves the
wrong answer problem.

Cheers,


Ann