Exasol Performance Expert
Zielgruppe:
Für Database Admins und Entwickler zur Optimierung der Performance Ihrer Exasol DB
english:After a short repetition of Exasol concepts and features relevant for analyzing system or query performance, this training course focuses on performance-relevant topics.
Nach erfolgreicher Absolvierung des Kurses können Sie eine Zertifizierungsprüfung ablegen!
This includes the following topics:
- Detection of bottlenecks using statistical system tables
- Data distribution
- Query execution in Exasol
- Query execution phases
- Pipelining
- Execution plans
- Profiling of queries
- Indexes in Exasol
- Use case “Indexscan”
- Best practices
- Database design: Dos and Don’ts regarding performance
- Query analysis and optimization (using well known issues)
Prerequisites:
EXASOL Certified Developer Alternative: thorough practical experience with the topics included in the developer training course, particular usage of statistical system tables (schema EXA_STATISTICS)