Re: How slow is DISTINCT?

From: "Dan Langille" <dan(at)langille(dot)org>
To: wweng(at)kencast(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How slow is DISTINCT?
Date: 2002-02-27 21:30:58
Message-ID: 200202272131.g1RLV7k94868@lists.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-02-27 21:45:16 Re: How slow is DISTINCT?
Previous Message postgresql 2002-02-27 21:07:20 Re: Large Objects