Optimizing ORDER BY with indexes?

Поиск
Список
Период
Сортировка
От Dirk Lutzebaeck
Тема Optimizing ORDER BY with indexes?
Дата
Msg-id 14462.57679.783969.863812@ampato.aeccom.com
обсуждение исходный текст
Ответы Re: [SQL] Optimizing ORDER BY with indexes?  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
Список pgsql-sql
I'm forced to used ORDER BY on large tables which then takes quite
long. Is there a chance to create/optimize an index for ORDER BY?
Or could I write an index method on my own? How would it look like?

Are there any other possiblities to speed up ORDER BY?

Dirk


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

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