Subject Re: [Firebird-Architect] Bi-directional indexes
Author Ann W. Harrison
Doug Chamberlin wrote:
>
> Here's an idea for Firebird 2: Whenever an index is requested, always
> create both an ascending and descending index. ...
>
> Cost: twice the indexing being done.
>
> Benefit: No need to further analyze the indexing mechanism at the moment or
> incur risks associated with a change to it.

Ah, but having this discussion now introduces some of the hard problems
in managing highly concurrent volatile data structures before we
implement a design that almost works.

Regards,


Ann