213: Analytic SQL for Beginners
Mark Inman , U. S. Navy    Biography

Objectives: Why analytic SQL is useful.
When analytic SQL should be used.
Understanding what makes one query faster than another.
Abstract: This is for people who have not used analytic SQL. We will do some very simple examples. Side benefits of attending are learning about (1) buffer gets with respect to query performance, (2) self-joins, (3) set autotrace details.

Audiernce Focus: Developers
Expertise: Advanced
Track: Business Intelligence/Warehousing
Date: Tuesday, April 15, 2008
Time: 9:45 AM - 10:45 AM