In this course, you will learn how to measure the performance of T-SQL queries and tune your query development for the specific requirements of your business. Take advantage of the monitoring and evaluation ASE tools, and interpret their diagnoses into specific plans of action.

This course is based on software release SAP ASE 16.0. SP4

Who Needs To Attend

  • Developers
  • Developer consultants

Topics Include

  • Optimization tools and their use
  • 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
Designed by  © Alliance Softech Pvt Ltd. All rights reserved.
WhatsApp chat