SORT GROUP BY NOSORT ROLLUP

(Oren Nakdimon) In the previous post we saw that the Oracle Optimizer has a special operation – SORT GROUP BY ROLLUP – for performing several aggregations of the same population in a single scan, as long as the grouping keys are in a “rollup form”; for example:

Register to Read