Performance and Tuning Adaptive Server Enterprise 16.0 Query Optimization EDB634

All Levels

Created by Ram Niwas Sangwan Last Updated 23/05/2021 10:03

₹47,500.00 ₹47,500.00 0.00% off

What's Included

  • 7 Lectures
  • 1 Assignments
  • Access on tablet and phone
  • Certificate of completion

Course Curriculum

Expand all Collapse all

7 Lectures

00:00

Description

Performance and Tuning Adaptive Server Enterprise 16.0 Query Optimization EDB634

Course Overview

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. SP 3

Who Needs To Attend

  • Developers
  • Developer consultants

Course Details

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

Instructors

(0.00)

21 Courses

225 Students

2 Reviews