October 20 SIRDUG Meeting Featuring Terry Purcell
WHEN? October 20 (Thursday)
IBM Harris Blvd facility (Charlotte, NC) - See directions below
COST? $25 cash or check, per day, at the door.
We do not accept credit cards.
Featured Speaker - Terry Purcell
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 10:15 - Terry Purcell "Can my WHERE clause use an index?"
10:15 - 10:30 - Mid-Morning Break
10:30 - 11:45 - Terry Purcell "What statistics are required by the DB2 optimizer?"
11:45 - 12:45 - Lunch
12:45 - 1:55 - Terry Purcell "How to Tune SQL Like an Expert in DB2 V8"
1:55 - 2:05 - Mid-Afternoon Break and chat with Terry
2:05 - 3:15 - Terry Purcell "Query Tuning When You Can't Change the SQL (indexing, clustering, partitioning)"
3:15 - 3:30 - Business meeting and installation of officers for 2006
3:30 - 4:00 - Networking, Adjourn
To pre-register please use our new online registration form at:
meeting registration form
email email@example.com and give us your name and company. If
you are not already on our distribution list and wish to be, include
your email address and phone number.
If you do not wish to continue receiving these occasional notices, please indicate that in
your registration email.
Pre-registration must be completed by Midnight, Friday, October 14th. Please
feel free to invite others from your company (just make sure
they pre-register as well). If you know others in your company who are
interested in attending future SIRDUG events, please encourage them to
become members of our distribution list (we just need their names, email
addresses and phone numbers).
SIRDUG will be calling or emailing a confirmation for each person who
pre-registers by the deadline. If you have pre-registered and have not
received a confirmation by the day after the deadline, please notify us as
your registration may not have been received.
If you have not pre-registered by the deadline, you may pre-register after
the deadline or register at the door, but the availability of presentation
handouts and lunch can not be guaranteed and confirmations will not be sent.
The meeting is in the IBM Harris Blvd facility
North bound on I-77 (from the Rock Hill direction): Turn right onto I-85
North and follow next directions.
On I-85 (coming from either direction): Take exit 45B onto Harris Blvd.
West Turn Left at 2nd stop light onto IBM Drive and follow directions below.
South bound on I-77 (from the Statesville direction) Turn left onto
Harris Blvd. East (exit 18) Go approximately 6.3 miles to the 10th
stop light (counting the one at top of I-77 ramp) Turn Right onto IBM
Drive (Don't turn onto the IBM Drive at the 7th stop light).
Once on IBM Drive, Turn Right at 2nd drive. Look for the SIRDUG parking sign
on the right side of the road. We are to park in the lower visitor parking
lot. Enter the Visitors Lobby and follow the SIRDUG signs to the Cafeteria
Terry Purcell is a senior software engineer in the DB2 for z/OS SQL Query
Technology Team with the IBM Silicon Valley Lab. Terry has more than 13
years experience with DB2 in Database Administration and application
development, and is a regular speaker on SQL performance and query
optimization at DB2 conferences worldwide.
"How to tune SQL like an expert"
Can my WHERE clause use an index?
A prominent DB2 consultant once said, “The 3 most important aspects of SQL
performance are filtering, filtering, and filtering”. The first part of this
session will focus on what elements of a SQL statement allow this filtering
to occur by explaining the topics of index matching, screening, stage 1 and
stage 2 predicates with V7 and V8 differences highlighted.
"What statistics are required by the DB2 optimizer?"
This presentation will help you answer the question: What statistics do I
need to collect and why? To ensure the DB2 optimizer has all information to
determine the most efficient access path. In addition, basic costing of the
various single table and multi-table join methods will be covered.
"Why did the optimizer choose that access path?"
One of the most pressing questions for SQL performance is: Why did the
optimizer choose the wrong access path? Before DB2 V8, you had to be an
optimizer expert to answer that question. This presentation will outline a
method to utilize the extensive access path detail available with V8 Visual
Explain and compare with the actual reality for a given query. The end result
is that you will be able tune SQL like an expert.
"Tuning SQL when you can’t change the SQL"
Sometimes you can’t change the SQL, because it’s adhoc, or from an ERP, it’s
a legacy application, or nobody wants to touch it!!!! Once statistics
accurately represent the data and the “best available” access path is chosen,
then there are physical design decisions that can be made to help boost
runtime performance further. Indexing, partitioning and clustering will be
discussed and how to exploit these, with the objective of maximizing filtering
and reducing I/O.
If you have any links that you would like to see on our pages,
send SIRDUG an EMAIL using our mail box below.
SIRDUG Home Page
Last Update: October 2, 2005
Copyright © 2005 SIRDUG Inc. All rights reserved.