Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
- Type product
Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
Opleiderscore:
Beschrijving
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…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
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
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.