Subject | Re: [Firebird-Architect] Clustered indexes |
---|---|
Author | Miroslav Penchev |
Post date | 2005-06-27T19:46:02Z |
On Mon, 27 Jun 2005 22:03:36 +0300, Thomas Steinmaurer
<ts@...> wrote:
On Sat, 25 Jun 2005 12:05:34 +0300, Dmitry Yemanov
<dimitr@...> wrote:
--
Miroslav Penchev
<ts@...> wrote:
> Hi Ann,Dmitry was write it shortly:
>
>>> 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.
>
On Sat, 25 Jun 2005 12:05:34 +0300, Dmitry Yemanov
<dimitr@...> wrote:
> "Simon Carter" <simon.carter@...> wrote:Cheers,
>>
>> 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
--
Miroslav Penchev