Re: does a table always need a PK?
From: Marshall Spight <mspight_at_dnai.com>
Date: Tue, 02 Sep 2003 23:05:34 GMT
Message-ID: <2n95b.256815$Oz4.67582_at_rwcrnsc54>
Date: Tue, 02 Sep 2003 23:05:34 GMT
Message-ID: <2n95b.256815$Oz4.67582_at_rwcrnsc54>
"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:Nv85b.19$1o4.1173_at_news.oracle.com...
>
> Since we can express count via sum, where
>
> select count(a + b) from table_t;
>
> becomes
>
> select sum(1) from table_t;
>
> could I suggest that "count" is redundant operator, so that we can drop it
> from consideration altogether?
I like that idea a *lot.*
Marshall Received on Wed Sep 03 2003 - 01:05:34 CEST