This 2 part presentation covers:
     What SQL Optimization is
     Stage 1 versus Stage 2 predicates
     What the DB2 Explain Tool does
     What makes queries run too long
     Learn what to do when you see a table scan taking place.
     Learn steps to tuning a query

Biography:

Tony Andrews has considerable experience in the consulting arena helping many companies design, program, tune, and install application systems to help their needs. He assists in technical solutions and helps developers through their learning curves. Strengths are in Relational Database systems (DB2, SQL Server, Oracle), with most experience in DB2. He has developed many sets of standards for companies in the areas of SQL coding, design, testing, implementation, and performance and tuning. Has also taught many classes to companies in these same areas.  He is skilled in the areas of SQL programming and performance tuning of applications.

Tony has authored a book titled 'DB2 75+ Tuning tips for Developers'. Available at the following website: www.db2sqltuningtips.com

Back to Top

TBD

TBD

Biography:

Brian Haley is a Information Management Solution Architect working for IBM. He has been implementing data warehouse and business intelligence solutions for the past 15 years and currently supports customers in the eastern US. Brian's specialties include Business Intelligence, Master Data Management, Information Integration and high performance OLTP applications

Back to Top