Oct 17th-18th - Cost-Saving Database Index Design Class - By Larry Kintisch - First Reminder

Cathy Peck

Oct 17th-18th - Cost-Saving Database Index Design Class - By Larry Kintisch - First Reminder

On Oct 17th-18th, Larry Kintisch will be returning to the area to teach
another class on Cost-Saving Database Index Design for the Central PA DB2
User Group. The class abstract is shown below & is also on the PA RUG
Website http://www.db2parug.org. Interested individuals should register
via:
http://www.DbIndexDesign.com/register.html. Tks. Seeya



A New Performance Course!
TL120 Cost-Saving Database Index Design
2 days with case study exercises

Next class is at Highmark Blue-Cross Auditorium,
Camp Hill Corporate Center Drive, Building 300
Camp Hill, PA October 17-18, 2005

“Inadequate indexing …
is the most common reason for
performance problems”

Has your best programmer saved your firm money today? …kept one customer
happy? …made your warehouse crew smile? …kept your call-center associates
from apologizing? Send your best programmers and application DBA's to our
two day class and we'll show them how to save thousands of dollars. It's
easy to teach a developer how to save $1,000 a month while producing a
top-notch system. Quick methods help estimate index performance while
clear procedures build the very best cost-saving index for any query.

Experienced instructors will teach those techniques in a two day class with
real-life
exercises to build skills. Your students will also get a copy of Tapio
Lahdenmäki's new book on index design for in-depth background, examples and
review.
Resister today …seats are limited.

Course Objective
Students learn a well-tested method to predict and detect inadequate
indexing as early as possible. They learn a technique to derive
cost-effective indexes for SELECT statements, including complex joins. In
addition to design for new applications, we teach methods for improving the
performance of existing database applications without changing application
programs. The recommendations and rules are based on current (2003)
hardware. With several design exercises and case studies from real systems,
the course is product-independent. These methods have been applied with
beneficial results in the following environments: Oracle, DB2 for z/OS, DB2
for Unix and Linux, INFORMIX, SYBASE and Microsoft SQL Server. Instructor
in the US: Larry Kintisch.

Audience: Database specialists Application developers who write
SQL queries Database administrators Project managers who
need background information about application performance management
For a complete description of the course and how to register online, see
the website:

http://www.DBIndexDesign.com


(Embedded image moved to file: pic16677.jpg)

A Senior DBA at a manufacturing firm says of the author: "...it is the
single best class I have taken. I was able to pass on about $67,000 a year
in CPU savings ... from his class. Tapio is an excellent [writer], very
patient, deliberate, makes sure [readers] understand the basic concepts and
then reinforces them with real life examples.
I can recommend him as one of the best talents out there."

FEE: $ 660 per student; discounted 10% for multiple registrations
per organization or for IT User Group members. {Non-profits: call for
discount.)
Contact: Larry Kintisch 845-353-0885 or 845-353-3809
Database Index Design is a division of ABLE Information Services
PO Box 809, Nyack NY
10960-0809

TL120 Cost-Saving Database Index Design


Next class is at Highmark Blue-Cross Auditorium,
Camp Hill Corporate Center Drive, Building 300
Camp Hill, PA October 17-18, 2005

Topics: There are 10 sections in the course and companion book that cover
index design issues for DB2, Oracle, SQL Server and other DBMS’s:
Case Study: Inadequate Indexing
Sequential and Random reads / QUBE - estimation of Touches / The
Index and the Fat Index
Evaluating Indexing Alternatives
Index Matching and Index Screening / The impact of Predicate Filter
Factor / Difficult Predicates
Quick Estimate for the Elapsed Time & Lab
Systematic Index Design
The Three-Star Index and 2 Alternatives & Lab / Filter Factor Pitfall
A Range of Improvements: Cost Options & Lab
Reactive Index Design: Improve Indexing of Operational Tables
Identify culprits and victims / Real-life examples, Spike Report from
trace & Lab
Design Indexes for a Nested Loop Join
Nested Loop Join Access Paths; Merge Scan / Hash Join / Table design:
denormalize & Lab
Unpredictable WHERE Clause Predicates
Input Screens with Optional Predicate Values / AND / OR: Multiple
Index Access
Bit map indexes: Advantages and restrictions / Star Join and Data
Warehouse Indexing
Summary tables
Index Free Space and Reorganization recommendations
Insert patterns and Clustering / Index Row size and Split Ratios /
Calculating Free Space for Indexes and Tables & Reorg. Frequency /
Optimizers are not perfect
Bad Access Path or Bad Cost Estimates / Helping the Optimizer: Hints
and Statistics
DBMS-specific options and restrictions and Computer-assisted index design

Note: A copy of Mr. Lahdenmäki's new textbook on relational database index
design and performance is included in the course material.

For a complete description of the course and how to register on-line, see
the website.

http://www.DBIndexDesign.com

DBA’s at firms trying to tune SAP and Peoplesoft packages tell us of their
frustration at not being able to change tables or application code. “Index
improvement is one of the only tuning tools we have.” This course provides
methods to accomplish package tuning through “fattening” existing indexes
and designing improved new indexes. This works for ORACLE, DB2 and other
platforms.


(Embedded image moved to file: pic09004.jpg)

The course is suited to database developers, DBA's, analysts designing
applications and managers concerned with database cost and performance.

FEE: $ 660 per student; discounted 10% for multiple registrations
per organization or for IT User Group members. {Non-profits: call for
discount.)
Contact: Larry Kintisch 845-353-0885 or 845-353-3809
Database Index Design is a division of ABLE Information Services
PO Box 809, Nyack NY
10960-0809 [20050914.]