Understanding Indexes

Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Indexes are chosen by the optimizer based on information that is perceived to be true. Gain an understanding of how perception can differ from reality and the impact that it can have on query performance. Study actual benchmark statistics for such actions as creating indexes, running update statistics and executing various queries under a number of real-life circumstances. Actual statistics on time and space requirements for indexes will enable System and Database Administrators to efficiently create and maintain the right indexes.

Course Objectives :
Upon completion of this course, you will be able to:
Document the "behind the scenes" steps of creating an index
Provide insight into why creating indexes require additional space and time
Explain how the optimizer can sometimes choose the wrong access method
Understand the optimizer’s need for statistically accuracy
Demonstrate actual time and space requirement for building indexes and running update statistics
Identify ways to reduce space requirements for building indexes
Course Topics:

Index selection for various queries.
Index structures and index record layouts.
I/O requirements for accessing various indexes.
The optimizer.
Systabstats and sysstatistics
Perception versus reality.
Concept of majority.
Statistical accuracy.
Manually changing perception.
The create index process.
Time and space statistics on the creating index process.
The update statistics process.
Time and space statistics on the updating statistics process.
Time statistics on queries using different locking schemes, types of indexes, index record lengths and volumes of data.
Who Should Attend: System and Database Administrators

Prerequisites:
Experience as a Sybase DBA in the following areas: Running update statistics, Creating indexes, Running optdiag, Familiarity with dbcc commands
Or
Previous attendance of the following courses for either v11.9.2, v12.0 or v12.5:
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise


...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

14800 Quorum
Suite 505
Dallas, Texas 75240
United States

8755 West Higgins Road
Suite 1100
Chicago, IL 60631

The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland

561 Virginia Rd.
Concord, MA 01742
(978) 287-1500

3820 Mansell Road
Suite 100
Alpharetta , GA 30022

19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612

Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.

Dynamic Reconfiguration for Managing Memory Nonstop Optimal Performance
Interpreting the Major ASE System Tables
Implementing ASE Replicator
Unix to Linux Migration for Adaptive Server Enterprise
Administering Sybase IQ for the Data Warehouse
Interpreting SP_SYSMON
Advanced Performance: Monitoring Tables Facility
Fooling, Cheating, Lying and Understanding the Optimizer
Open Client Programming Using Client-Library
Open Server Programming
Harness the Power with Configurable Parameters
Using SybMigrate
Powering Up to ASE Interim Releases
Introduction to SQL Expert
Behind the Scenes with DBCC Commands
Backup Server Unleashed
Securing Adaptive Server Enterprise Communications
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Fast Track to Adaptive Server Enterprise

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.