Re: Deadly sins againts database performance/scalability

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 28 Nov 2003 10:21:09 -0800
Message-ID: <1070043699.141551@yasure>

Cris Carampa wrote:

> Marc Blum wrote:
>

>> (1) SELECT DISTINCT ...

>
>
> Sorry for the naive question: what's wrong with SELECT DISTINCT?
>
> Kind regards,
>

Nothing when used appropriately. It has a cost associated with it and thus should only be used when it is required to produce the correct result.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Nov 28 2003 - 12:21:09 CST