View Printable Version
Come, miscode some SQL with me…
General II (F)
Suresh Sane [Database Architect - DST Systems Inc]
Kepler => Mon, Nov 14, 2011 (01:30 PM - 02:30 PM)
Suresh Sane is an IDUG Hall of Fame speaker who has lectured worldwide and co-authored 4 IBM Redbooks (Dynamic SQL, Stored Procedures, Data Integrity and DB2 Packages). He was recognized as an IBM Information Champion in 2009, 2010 and 2011. He is a long time IDUG volunteer and was the Conference Chair for IDUG NA 2008. He currently serves on the IDUG Board of Directors.
Audience experience level:
DB2 for z/OS
Audiences this presentation will apply to:
Application Developers, Data Architects, Database Administrators, New Users
Technical areas this presentation will apply to:
SQL and XML Features, SQL and XML Performance
SQL examples of DOs and DON'Ts
Let me count the ways I can code thee
Talking about Temporary tables
But it's just a small table?!
Making the optimizer read your mind
Presentations advocating best practices abound. Welcome to the real world! We all know several bad practices are routinely followed in several shops. In addition, some ‚Äúclever‚Äù practices can be harmful in the long run. This session will cover some of the common patterns I have seen in my design reviews. We will discuss why they occur, how to detect them and how to prevent them.