Recursive SQL for Solving Real Business Problems
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
Audience: Data Warehouse Administrator, Data Warehouse Application Specialist, Data Warehouse Architect/Designer
Course number: | 48443 |
---|---|
Training URL: | http://www.teradata.com/t/ten/ |
Format: | Recorded webcast |
Price: | $195.00 |
Credit hours: | 1.00 |