This is a text description of the screenshot sumtab1.gif. The screenshot shows a sample table showing that Discoverer knows it is faster to aggregate from a single table than from a six table join and full table scan.