Oracle® 11g: Performance Tuning of SQL Expressions
Продолжительность
32
часы
Місцезнаходження
Онлайн
Мова
Англійська
Код
DB-002
Тренінг для 7-8 чи більше людей?
Налаштуйте тренінги
для ваших конкретних потреб
опис
The course describes the methodology that can be used for solving various performance problems related to Oracle SQL – more specifically the 11g version.
Після проходження курсу видається сертифікат
на бланку Luxoft Training
на бланку Luxoft Training
Цілі
- Understand the stages of executing SQL expressions
- How to retrieve statistical data on execution of SQL expressions
- Solving performance problems by adjusting SQL expressions
Цільова аудиторія
- Database administrators
- System administrators
- Application developers
- Software Testers
Дорожня карта
- Tuning methodology
- Processing SQL expressions
- EXPLAIN and AUTOTRACE: tools used to monitor execution plan of SQL statement
- Performance diagnostics tools SQL*TRACE and TKPROF
- Rule-Based Optimization and Cost-Based Optimization
- Indexes and the main methods of data access
- Statistics collection for optimizer
- Operation modes of optimizer. Factors influencing optimizer’s work. Hints to optimizer
- Sorting and merging tables
- Query execution plan (Stored Outline)
- Extended indexing features (bitmap indexes and function-based indexes)
- Materialized views and temporary tables
- Alternative data storage (Index-organized tables and clustered indexes)
- New features of version 11g