| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: U_SUMMARIZE: how aggregate is calculated?
"Alfredo Novoa" <alfredo_at_ncs.es> wrote in message
news:41af01f4.3703453_at_news.wanadoo.es...
> On Wed, 1 Dec 2004 17:59:11 -0800, "Mikito Harakiri"
> I that case Sum(1) would be equivalent to Count(R) and the result
> would be 3.
After reading "Temporal Data" my impression was that relation cardinality doesn't matter anymore. Although facts are still stored as tuples, they are easily merged with each other (pack) or partitioned into smaller ones (unpack).
Let me try stating the problem formally. Given
R: {A=[1,2], A= [3,5], A= [4,7]}
what is the result of
USING ( A ) <| SUMMARIZE R
PER TABLE_DEE
ADD SUM(1) AS THE_SUM_IN_QUESTION |>
Unlike ordinary SUMMARIZE there is a USING clause. Does it have any effect
at all?
Received on Thu Dec 02 2004 - 12:02:36 CST
![]() |
![]() |