Does your data warehouse contain organizational hierarchies, bills-of-material, or transportation networks? If so, you likely have a good candidate business problem for recursive SQL...

Data often contain parent-child relationships, for which recursive SQL is well suited. In addition, when the solution to a problem requires multiple iterations, rather than a single pass of data, recursive SQL is an alternative. This session provides an overview of recursive SQL, then solves multiple business questions, using both non-recursive and recursive SQL. The session uses DBQL metrics of Elapsed Time, CPU Time, IO Count, and Spool Usage to compare performance of the non-recursive and recursive SQL solutions. Lastly the session offers considerations for when to choose recursive SQL.

Note: This was a 2010 Teradata Partners Conference session.

Presenter: Darrin Gaines, Senior Consultant - Teradata


This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Audience: Data Warehouse Administrator, Data Warehouse Application Specialist, Data Warehouse Architect/Designer

Course number 48443
Training URL
Format Recorded webcast
Price $195.00
Credit hours 1.00