Feb. 10-11 in Philadelphia - Index Design Class

Cathy Peck

Feb. 10-11 in Philadelphia - Index Design Class




Greetings! Below are details on an upcoming Index Design Class in Phila
that I was asked to share w/the group. Please pass along to anyone
interested. Tks. Seeya



For Oracle, DB2, INFORMIX, SYBASE & Microsoft SQL Server
A New2-day Performance Course!
Cost-Saving Database Index Design
Next class: Feb. 10-11 at Right Source , , One Penn Center at
Suburban Station, 1617 JFK Blvd., Suite 1260, Philadelphia, PA
“Inadequate indexing . . . is the most common reason for performance
problems”

Even your best programmer can waste money! You wouldn’t allow an
“incorrect” program to run: why isn’t a “too-slow” query or report
considered a costly, poor quality defect? Send your best programmers and
application DBA's to our two day class and we'll show them how to save
thousands of dollars each month. It's easy to teach a developer or DBA how
to save money 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 or report.

Course Objectives: 1) Students come away understanding how an RDBMS
optimizer works with indexes, calculates filter factors, chooses access
paths and uses indexes in different ways. 2) Students learn a well-tested
method --QUBE-- to predict performance early during development and detect
inadequate indexing. 3) They learn systematic index design, a technique to
derive cost-effective indexes for SELECT statements -- including complex
joins and data ware- house queries. 4) Students learn to design
high-performance fat indexes (and "covering indexes") that are a good
cost-benefit trade-off with new, lower cost hardware. These techniques also
improve the performance of existing database applications without changing
application programs. The design exercises and case studies are from real
systems. The course is product-independent and have been beneficial with
Oracle, DB2 for z/OS, DB2 for Unix and Linux, INFORMIX, SYBASE and
Microsoft SQL Server.

Larry Kintisch, an experienced instructor [20 yrs. RDBMS], teaches those
techniques in a two day class with real-life exercises to build skills.
FREE! Your students will also get a revised manuscript copy of Tapio
Lahdenmäki's new book on index design for in-depth background, examples and
review. Register today at the web site below … seats are limited.



Audience: Database specialists Application developers who write SQL
queries Database administrators Project managers who need
background information about application performance management. Email us a
“White Paper request” to receive Chap. 1 of the author’s text. For a
complete description of the course and how to register online, see the
website:

http://www.DBIndexDesign.com

A Senior DBA at a manufacturing firm says: "...it is the single best class
I have taken. I was able to pass on about $67,000 a year in CPU savings ...
from the 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..”

FEE: $ 690 per student; discounted 10% for multiple registrations per
organization
or for IT User Group members. Pay by credit card, corporate check or
corporate Purchase Order.

Contact: Larry Kintisch 845-353-0885 or 845-353-3809
[login to unmask email]
ABLE Information Services, PO Box 809, Nyack NY 10960-0809

A New Performance Course!
Cost-Saving Database Index Design

Next classes: Feb. 10-11 at Right Source , Philadelphia
Mar. 03-04 T.B.A. in Hoboken/Jersey
City
Topics: There are 14 topics in the course and companion book that cover
index design issues for DB2, Oracle, SQL Server and other DBMS’s:

Introduction to database performance with current hardware
Evaluating indexing alternatives
The cost of an index

Deriving the ideal index for a complex one-table SELECT
Case studies: Design cost-effective indexes for complex one-table
SELECT's
Improving the indexing of operational tables

A common and non-trivial problem: Designing indexes for a nested loop join
Case study: Design indexes for a traditional join
Index free space and reorganization recommendations

Indexing Data Warehouse tables
Multiple index access (index AND-ing and index OR-ing)
Bit map indexes: Advantages and restrictions

Unpredictable WHERE clauses (many optional columns)
DBMS-specific options and restrictions
Optimizers are not perfect
Computer-assisted index design

FREE! A pre-publication copy of Mr. Lahdenmäki's new textbook on relational
database index design and performance is included in the course material:
email us to receive Chap. 1,


requesting “White Paper.” For a complete description of the course and how
to register on-line, see the website.

http://www.DBIndexDesign.com

DBA’s at firms with 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.

FEE: $ 690 per student; discounted 10% for multiple registrations per
organization or for IT User Group members. Payment by credit card,
corporate check or corporate Purchase Ord.

Contact: Larry Kintisch 845-353-0885 or 845-353-3809
[login to unmask email]
ABLE Information Services, PO Box 809, Nyack NY 10960-0809