Re: [SQL] Optimizing ORDER BY with indexes?

Поиск
Список
Период
Сортировка
От Dirk Lutzebaeck
Тема Re: [SQL] Optimizing ORDER BY with indexes?
Дата
Msg-id 14462.60668.225811.469623@ampato.aeccom.com
обсуждение исходный текст
Ответ на Optimizing ORDER BY with indexes?  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
Ответы Re: [SQL] Optimizing ORDER BY with indexes?  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
Re: [SQL] Optimizing ORDER BY with indexes?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [SQL] Optimizing ORDER BY with indexes?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-sql
Dirk Lutzebaeck writes:> > I'm forced to used ORDER BY on large tables which then takes quite> long. Is there a chance
tocreate/optimize an index for ORDER BY?> Or could I write an index method on my own? How would it look like?> > Are
thereany other possiblities to speed up ORDER BY?
 

Reading about indexes in the Bowman SQL book I think a 
_clustered index_ is needed for the problem above.
Does Postgresql support these?

Dirk



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

Предыдущее
От: Dirk Lutzebaeck
Дата:
Сообщение: Optimizing ORDER BY with indexes?
Следующее
От: Dirk Lutzebaeck
Дата:
Сообщение: Re: [SQL] Optimizing ORDER BY with indexes?