Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
- Product type
Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
Provider rating:
Description
Goals
- Understand optimization in ASE 15.0
- Explain new optimization tools and their use
- Utilize application tracing and QP Tune to assist in code tuning
- Discuss the steps involved in executing code from input to return of result set
- Use code to pass hints to the optimizer
- Force optimization steps on the Optimizer
- Take advantage of new options to configure the optimizer
- Generate faster, more efficient code
Audience
- SQL Developers
- Application Developers who use SQL code
- Database Administrators and/or Sybase System Administrators who are involved in tuning queries
- Performance and Tuning Specialist
- Any computer professional who needs an understanding of how the Sybase Query Optimizer works
Pr…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Goals
- Understand optimization in ASE 15.0
- Explain new optimization tools and their use
- Utilize application tracing and QP Tune to assist in code tuning
- Discuss the steps involved in executing code from input to return of result set
- Use code to pass hints to the optimizer
- Force optimization steps on the Optimizer
- Take advantage of new options to configure the optimizer
- Generate faster, more efficient code
Audience
- SQL Developers
- Application Developers who use SQL code
- Database Administrators and/or Sybase System Administrators who are involved in tuning queries
- Performance and Tuning Specialist
- Any computer professional who needs an understanding of how the Sybase Query Optimizer works
Prerequisites
Essential- * Fast Track to Adaptive Server Enterprise
Content
- Access methods for queries and data modification
- Costs and benefits of indexes
- Query optimizer
- Statistics
- Optimization Goals and Criteria
- Joins and join types
- Parallel queries
- Stored procedure compilation and performance
- New index and partitioning behavior
- Metrics, MDA monitoring, and Abstract Query Plans
- Application Tracing
- QP Tune and Compatibility Mode
Notes
- Designed as a core requirement for ASE SQL Developers who want to explore the Adaptive Server Enterprise 15.0 Query Optimizer so as to enable them to improve the performance of their queries. This course is also the core requirement in our ASE 15 Migration for Developers training program.
- Learn 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 tools of Adaptive Server Enterprise 15.0, and interpret their diagnoses into specific plans of action. Perform tasks to evaluate the behavior of the optimizer in ASE 15, and implement the most efficient data-change and data-retrieval T- SQL code in your queries and stored procedures. You will also use various Sybase utilities to identify causes of slow queries, and learn techniques in resolving these problems.
Popular tags
No tags submitted for this course yet
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.