Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Teach SELECT DISTINCT first!

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@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 - 13:41:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US