Cross Platform DB2 for z/OS & LUW

DB2 Advanced SQL and Performance 

Sep 07, 2015 10:05 AM

This seminar address advanced SQL syntax and coding techniques with query performance in focus. Examples of complex SQL in different formulations are shown to demonstrate those that they perform efficiently versus those that perform in the worst possible manner. DB2 brought a whole new world to relational with advancements in SQL processing and object relational support. Presented here are the more advanced examples of subqueries, joins, anti-joins, table expressions, CASE expressions, UDFs, table functions, SQL recursive processing, relational division, OLAP expressions, PureXML, and many other features of the DB2 family. There are many examples taken from real systems. An emphasis is made on the proper use of each technique for performance.

Attachment(s)
pdf file
ED3 Luksetich Advanced SQL and Performance AU2015.pdf   4.22 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.