Re: How slow is DISTINCT?

On 27 Feb 2002 at 13:27, Wei Weng wrote:

> I tend to use DISTINCT a lot in my queries to limit the repeated rows. Is
> that a good habbit?

If that's what you need, use it.

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

Try it.  Compare the same SQL with and without DISTINCT.
-- 
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples