Re: What are the benefits of using a clustered index?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: What are the benefits of using a clustered index?
Дата
Msg-id 1237296727.3953.103.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: What are the benefits of using a clustered index?  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: What are the benefits of using a clustered index?
Re: What are the benefits of using a clustered index?
Список pgsql-general
On Tue, 2009-03-17 at 09:16 -0400, Alvaro Herrera wrote:
> > I'm quite sure SQL Server doesn't work this way and I'm not sure
> about
> > Oracle.  Can someone enlighten me on the exact benefit of this?
> Thanks!!
>
> Yeah, they use a completely different definition of "clustered index"
> from ours.

Hopefully we regard it as a missing feature rather than as a separate
definition. We could cluster the index, we just don't, yet.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


В списке pgsql-general по дате отправления:

Предыдущее
От: c k
Дата:
Сообщение: Re: different results for large objects
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: PostgreSQL versus MySQL for GPS Data