Re: Teach SELECT DISTINCT first!

From: <>
Date: Wed, 28 Apr 2004 18:41:46 +0000 (UTC)
Message-ID: <c6otta$21k$>

> 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

Original text of this message