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