How slow is DISTINCT?

Поиск
Список
Период
Сортировка
От Wei Weng
Тема How slow is DISTINCT?
Дата
Msg-id 3C7D252A.3030608@kencast.com
обсуждение исходный текст
Ответы Re: How slow is DISTINCT?  ("Josh Berkus" <josh@agliodbs.com>)
Re: How slow is DISTINCT?  ("Dan Langille" <dan@langille.org>)
Список pgsql-sql
I tend to use DISTINCT a lot in my queries to limit the repeated rows.
Is that a good habbit?

How exactly slow is DISTINCT being processed in SQL engines? (not
limited to postgresql, though comments on postgresql would be most relevant)

Thanks

-- 
Wei Weng
Network Software Engineer
KenCast Inc.




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

Предыдущее
От: Jeff Self
Дата:
Сообщение: Re: implementation of a many-to-many relationship
Следующее
От: "Dan Langille"
Дата:
Сообщение: Re: implementation of a many-to-many relationship