Articles & Content

Archives

Solutions for SQL Gone Wild (G12)

Topic: 2007 NA

Subtopic: DB2 for z/OS



DATE: 2007-5-10 (09:20 AM - 10:20 AM)
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



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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