Oracle® 11g: Performance Tuning of SQL Expressions
Durată
32
ore
Locație
Pe net
Limba
Engleză
Cod
DB-002
Training pentru 7-8 sau mai multe persoane?
Personalizați antrenamentele
pentru nevoile dumneavoastră specifice
Descriere
The course describes the methodology that can be used for solving various performance problems related to Oracle SQL – more specifically the 11g version.
După finalizarea cursului, se eliberează un certificat
în formularul Luxoft Training
în formularul Luxoft Training
Obiective
- Understand the stages of executing SQL expressions
- How to retrieve statistical data on execution of SQL expressions
- Solving performance problems by adjusting SQL expressions
Public țintă
- Database administrators
- System administrators
- Application developers
- Software Testers
Foaia de parcurs
- 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