Articles & Content

Archives

Solutions for SQL Gone Wild (G04)

Topic: DB2 for z/OS

Subtopic: 2007



DATE: 2007-5-7 (04:20 PM - 05:20 PM)
SPEAKERS: Sheryl Larsen (Sheryl M. Larsen, Inc.)

SQL is the nucleolus of every relational DBMS. Sometimes applications are designed with the specific custom queries; sometimes the queries are generated by a tool and sometimes a mixture of the two. SQL performance is independent of the design source or is it? Over time, SQL performance can become unpredictable. Come see examples of SQL gone wild. Solutions for taming and preventing the phenomena will be provided.

EXP. LEVEL: Intermediate

OBJECTIVES:

Short history of SQL

Identify characteristics of SQL gone wild

Identify sources of SQL gone wild

Share solutions for taming SQL

Share solutions for preventing SQL going wild



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.