Subject Re: [Firebird-Architect] Clustered indexes
Author Miroslav Penchev
On Mon, 27 Jun 2005 22:03:36 +0300, Thomas Steinmaurer
<ts@...> wrote:

> Hi Ann,
>
>>> If it doesn't take the conversation too off topic, what about support
>>> for
>>> clustered index's?
>>>
>>
>>
>> Yes it does, and the first answer is "over my dead body." If anyone is
>> interested in more specifics - I'll be glad to continue the discussion.
>
> Yes, I would be interested, if you don't mind.
>

Dmitry was write it shortly:

On Sat, 25 Jun 2005 12:05:34 +0300, Dmitry Yemanov
<dimitr@...> wrote:

> "Simon Carter" <simon.carter@...> wrote:
>>
>> If it doesn't take the conversation too off topic, what about support
>> for
>> clustered index's?
>
> Why do you think we need them? Unlike other databases, our index scan
> produces an optimized bitmap, so data pages are always read in their
> storage
> order. And we cannot avoid looking at data pages anyway, as we're
> required
> to chase the record versions chain.
>
>
> Dmitry

Cheers,
--
Miroslav Penchev