Performance and Tuning: ASE Query Optimizer 15.0 (ASE4)

Databases, SAP Sybase

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Principles of Performance and Tuning
    1. Defining Performance and Tuning Terms
    2. Defining Tuning Methodology
  • Query Processing and Execution
    1. Identifying the Client and Server Relationship
    2. Defining the Query Scheduling Process
    3. Defining the Optimization Process
  • The Tuning Toolbox
    1. Using Diagnostic Tools for Tuning
    2. Using Non-Session Tools for Tuning
    3. Using Syntax Commands for Tuning
  • Table Structures
    1. Identifying Table Structures
    2. Partitioning Tables
  • Index Structures
    1. Designing an Index
    2. Creating Function-Based Indexes
    3. Defining an Index Partitioning Strategy
  • Optimizer Statistics
    1. Creating Optimizer Statistics
    2. Examining Optimizer Statistics
    3. Managing Optimizer Statistics
    4. Tuning Statistic Maintenance
  • Query Optimization
    1. Identifying the Phases of the Optimization Process
    2. Controlling the Optimizer
    3. Determining Compatibility Issues
  • Access Method Optimization
    1. Optimizing Access Methods
    2. Determining Query Strategies
    3. Estimating the Costs of Queries
  • Joins
    1. Analyzing Joins
    2. Tuning Joins
  • Parallelism
    1. Examining Parallel Query Plans
    2. Configuring Parallelism
    3. Examining Runtime Adjustments
    4. Troubleshooting Parallelism Issues
  • Additional Optimization Techniques
    1. Using Optimization Techniques
    2. Defining Optimization Components
    3. Optimizing Operators
    4. Using Aggregate Processing
  • Data Modifications
    1. Inserting Tables
    2. Deleting Tables
    3. Updating Tables and Indexes
  • Stored Procedure Optimization
    1. Optimizing Stored Procedures
    2. Troubleshooting Stored Procedure Issues
    3. Costing Temporary Tables in Stored Procedures
    4. Tuning Stored Procedures
  • Optimizer Statistics Tuning
    1. Tuning Column Statistics
    2. Creating Simulated Statistics
  • Abstract Plans
    1. Defining Abstract Plans
    2. Creating Abstract Plans
    3. Tuning Abstract Plans
  • Performance Monitoring
    1. Forcing the Optimizer
    2. Monitoring Query Plan Performance
Schedule:
5 days (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: