Slide 5 of 39
Notes:
Comparison of attributes:
Dup. Removal- all
Aggregation- only on attributes in the by-list of aggrefate functions
Duplicate items:
Dup. Removal- immediately dropped
Aggregation- some calculation done before dropping