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
