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.
Sybase Training Audience:
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.
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.
Sybase Training Course outline
Showplan statement level output
Shape of query plans
Query plan operators
Referential integrity query plans
Join query plans
Instead of trigger plans