Re: [GENERAL] Joins and links

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] Joins and links
Дата
Msg-id 199907051603.MAA04492@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Joins and links  (Maarten Boekhold <boekhold@tibco.com>)
Список pgsql-general
>
>
> David Warnock wrote:
> > A solution I have seen in some sql dbms (eg MS SQL Server) is to be able
> > to choose one index and have the database table sorted by this index.
> > Then you don't need a separate index for that sort-order. It means that
> > almost any index can work like a recnum and avoid looking in both the
> > index and the data. I am trying to remember the name of this feature but
> > cannot at the moment.
>
> CLUSTER ?
>

man cluster.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: David Warnock
Дата:
Сообщение: Re: [GENERAL] Joins and links
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Joins and links