next up previous
Next: Optimization in CUBE computation Up: No Title Previous: Motivation

CUBE Operator

It computes Group-Bys of corresponding to all possible combinations of a list of attributes.

Example : For the Transaction Table Query :
Select P, D, C, Sum(S)
From Transactions
CUBE-BY P, D, C
will compute, 8 group-bys corresponding to all possible subsets of set { P, D, C }.



DBMS
1999-04-01