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
