How slow is DISTINCT?

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How slow is DISTINCT?
Date: 2002-02-27 18:27:54
Message-ID: 3C7D252A.3030608@kencast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gregory Wood 2002-02-27 19:14:02 Re: System Messages
Previous Message Dan Langille 2002-02-27 18:07:50 Re: implementation of a many-to-many relationship