Subject Re: [firebird-support] Using index-optimizer with max(xfield) function
Author Helen Borrie
At 10:37 AM 20/11/2003 +0100, you wrote:
>Helen,
>
>In such a situation, mySQL will actually maximize the ASC index. As
>Alexander told me, FB can't behave so because of the unidirectional nature
>of its b-tree indices.
>
>Fine. I don't know much about index structures. To satisfy my curiosity, can
>you tell me what sibling advantage(s) bring unidirectional indices ?
>There cannot be only limitations ... right ? ;-)

Right. If you do want to have a discussion about it, raise a question in
firebird-architect. It's a fascinating topic: just not one I have time to
write a book about just now. :-)

Helen