| Presentation Title: | All about grouping |
| Speaker: | Mr Rob van Wijk |
| Company: | CIBER |
| Co-presenter: | |
| Presentation abstract: | In version 8 and 9, Oracle introduced rollups, cubes and grouping sets. These extensions are by far not as well known as the traditional grouping. However, they do provide a wealth of new power to the job of aggregating. This session shows how they work, how to calculate with them, which supporting functions exist, how to interpret their execution plan and when they provide better performance. |
| Presentation begins: | 02/12/2009 13:50 |
| Presentation duration: | 60 |
| Presentation content level: | 2 (1 = indepth, 5 = strategic overview) |
| Audience experience: | All Experience Levels |
| Audience function: | DBA's, Developers |
| Speaker biography: | Rob has worked with Oracle databases and related products since 1995, mainly as a database application developer. He's a frequent contributor to OTN's SQL and PL/SQL Forum and writes about Oracle on his blog: rwijk.blogspot.com. In 2008 he received the Oracle ACE award for his contributions to the Oracle community. |
| Related topics: | Server Technology: General Technology |
| Hall: | Hall 8A |
