Subject | Re: [firebird-support] Using index-optimizer with max(xfield) function |
---|---|
Author | Helen Borrie |
Post date | 2003-11-20T11:08:29Z |
At 10:37 AM 20/11/2003 +0100, you wrote:
firebird-architect. It's a fascinating topic: just not one I have time to
write a book about just now. :-)
Helen
>Helen,Right. If you do want to have a discussion about it, raise a question in
>
>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 ? ;-)
firebird-architect. It's a fascinating topic: just not one I have time to
write a book about just now. :-)
Helen