Subject | Re: [firebird-support] Re: Not using index for MAX |
---|---|
Author | Ann W. Harrison |
Post date | 2007-10-29T15:22:20Z |
Adam wrote:
deadlocks unless one direction or the other is treated as unsafe.
The code to handle unsafe pointers is large, slow, and tends to be
buggy.
Regards,
Ann
>The real problem is that bi-directional indexes lead cause internal
> Bidirectional indices take up more space and so must be less dense
> than unidirectional indices. Having larger indices means that you have
> more sparse index pages and reading the index to will take longer.
deadlocks unless one direction or the other is treated as unsafe.
The code to handle unsafe pointers is large, slow, and tends to be
buggy.
Regards,
Ann