You won’t see any difference since you’re only rolling up a single column. Consider an example where we do
ROLLUP (YEAR, MONTH, DAY)
With a ROLLUP, it will have the following outputs:
YEAR, MONTH, DAY
YEAR, MONTH
YEAR
()
With CUBE, it will have the following:
YEAR, MONTH, DAY
YEAR, MONTH
YEAR, DAY
YEAR
MONTH, DAY
MONTH
DAY
()
CUBE essentially contains every possible rollup scenario for each node whereas ROLLUP will keep the hierarchy in tact (so it won’t skip MONTH and show YEAR/DAY, whereas CUBE will)
This is why you didn’t see a difference since you only had a single column you were rolling up.