Winter Savings - Save on IT Training Using Promo Code FROSTBYTE


Performance and Tuning: Adaptive Server Enterprise 16.0 Query Optimization

  • Tuition USD $4,090 GSA  $3,037.78
  • Reviews star_rate star_rate star_rate star_rate star_half 1527 Ratings
  • Course Code EDB634-v015
  • Duration 5 days
  • Available Formats Classroom

Skills Gained

  • Explain optimization tools and their use
  • Discuss the steps involved in executing code from input to return of result set
  • Use code to pass hints to the Optimizer
  • Perform tasks to evaluate the behavior of the optimizer
  • Implement the most efficient data-change and data-retrieval T-SQL code in your queries and stored procedures
  • Force optimization steps on the Optimizer

Who Can Benefit

  • Developer
  • Developer Consultant


  • Essential:
       -EDB116 or equivalent knowledge
  • Recommended:

Course Details

Course Content

  • Principles of Performance and Tuning
       -Defining Performance and Tuning Terms
       -Defining Tuning Methodology
  • Query Processing and Execution
       -Identifying the Client and Server Relationship
       -Defining the Query Scheduling Process
       -Defining the Optimization Process
  • The Tuning Toolbox
       -Using Diagnostic Tools for Tuning
       -Using Non-Session Tools for Tuning
       -Using Syntax Commands for Tuning
  • Table Structures
       -Identifying Table Structures
       -Partitioning Tables
  • Index Structures
       -Designing an Index
       -Creating Function-Based Indexes
       -Defining an Index Partitioning Strategy
  • Optimizer Statistics
       -Creating Optimizer Statistics
       -Examining Optimizer Statistics
       -Managing Optimizer Statistics
       -Tuning Statistic Maintenance
  • Query Optimization
       -Identifying the Phases of the Optimization Process
       -Controlling the Optimizer
       -Determining Compatibility Issues
  • Access Method Optimization
       -Optimizing Access Methods
       -Determining Query Strategies
       -Estimating the Costs of Queries
  • Joins
       -Analyzing Joins
       -Tuning Joins
  • Parallelism
       -Examining Parallel Query Plans
       -Configuring Parallelism
       -Examining Runtime Adjustments
       -Troubleshooting Parallelism Issues
  • Additional Optimization Techniques
       -Using Optimization Techniques
       -Defining Optimization Components
       -Optimizing Operators
       -Using Aggregate Processing
  • Data Modifications
       -Inserting Tables
       -Deleting Tables
       -Updating Tables and Indexes
  • Stored Procedure Optimization
       -Optimizing Stored Procedures
       -Troubleshooting Stored Procedure Issues
       -Costing Temporary Tables in Stored Procedures
       -Tuning Stored Procedures
  • Optimizer Statistics Tuning
       -Tuning Column Statistics
       -Creating Simulated Statistics
  • Abstract Plans
       -Defining Abstract Plans
       -Creating Abstract Plans
       -Tuning Abstract Plans
  • Performance Monitoring
       -Forcing the Optimizer
       -Monitoring Query Plan Performance


  • The course material is available in English only
  • This course prepares you for the Development Consultant Certification exam

Course based on software release

  • SAP ASE 16.0

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great experience with using the online training with Webcam and Zoom. It is as if I was there in the same classroom but in the comfort of my own setting.

ExitCertified was a good platform to use to develop the relevant skills and we learned a lot on how to actually spin up the tools and services we were learning about.

Everything went well. Enrollment process was easy and I always felt welcomed throughout the whole experience.

ExitCertified has well experienced and professional instructors that make their training sessions a remarkable one.

I really enjoyed the Architecting on AWS class. The class was very informative about all the AWS tools that we can use and will need when we go to the cloud.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward