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: bags vs. sets

Re: bags vs. sets

From: Gene Wirchenko <genew_at_ocis.net>
Date: Tue, 15 May 2007 16:48:15 -0700
Message-ID: <eihk43hch9rd46t5v0ji913hm47rk1piv1@4ax.com>


Marshall <marshall.spight_at_gmail.com> wrote:

[snip]

>Vadim has pointed out that there is a clear progression
>in algebraic properties from set -> bag -> list. But in
>set -> bag, you only give up idempotence. Is that a
>big deal?

     I think so. If you have a key that uniquely identifies a row, then you can stop looking for it once you find it. If there can be more than one, then you still have to keep looking. That is going to affect optimisation.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.
Received on Tue May 15 2007 - 18:48:15 CDT

Original text of this message

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