Re: Teach SELECT DISTINCT first!
From: <askot_at_ut.ee>
Date: Wed, 28 Apr 2004 18:41:46 +0000 (UTC)
Message-ID: <c6otta$21k$1_at_kadri.ut.ee>
Date: Wed, 28 Apr 2004 18:41:46 +0000 (UTC)
Message-ID: <c6otta$21k$1_at_kadri.ut.ee>
> In particular, eliminating duplicate rows is a big step towards making the
> result table LOOK like a relation.
Often the need for eliminating duplicates comes from a poorly designed query. Poor design means often bad news for the optimizer and for the overall perfomance.
Asko... Received on Wed Apr 28 2004 - 20:41:46 CEST