Sybase Training Overview:

The Interpreting Sybase Showplans class provides the students with a detailed understanding of the methodology they can use to read and interpret Sybase showplans. Class participants will learn how to verify and correct the performance concerns of the queries they wrote by reading and interpreting their query plans.

Upon completion of the course, the students will have a detailed knowledge of the manner by which to achieve the most practical and efficient Sybase query performance as displayed through their query plans.

Sybase Training Objectives:

Upon successful completion of this course, participants will be able to both understand how to read and interpret query plans in order to obtain very efficient query processing.

The student will understand the internal means by which the optimizer processes, and will be knowledgeable of the advantages of Sybase indexes, the usage of optimizer tracing tools, and parallel processing in Sybase.

Sybase Training Prerequisites:

Students should be able to code Sybase SQL and Transact_SQL queries.

Sybase Training Audience:

This course is recommended for applications programmers, system and database administrators, database designers and all other related personnel who require an in-depth understanding of the means by which the Sybase optimizer functions and produces its output in a showplan.

Course duration:

1 day

Sybase Training Course outline

Set showplan

Set statistics

Showplan statement level output

Shape of query plans

Query plan operators

Scan processing

Seek processing

Referential integrity query plans

Join query plans

Nested loops

Sort merge

Hash joins

Semijoins

Sorting

Aggregations

Compute processing

Union processing

Subquery plans

Instead of trigger plans

Cursor plans