Képzési forma:
Normál
Képzés hossza:
3 nap (24 óra)
Képzés nyelve:
Magyar/Angol
Ismertető
Oracle Database 19c SQL Tuning Workshop
This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.
Tematika
Learn To:
- Interpret execution plans and the different ways in which data can be accessed.
- Decipher, decide and then apply tuning to SQL code.
- Use various tuning techniques.
- Take advantage of bind variables, trace files and use the different types of indexes.
- Use different access paths for better optimization.
Outline:
- Course introduction
- Introduction to SQL Tuning
- Using application Tracing Tools
- Optimizer Fundamentals
- Generating and Desplaying Execution Plans
- Interpreting Execution Plans and Enhancements
- Optimizer: Table and Index Access Paths
- Optimizer: Join Operators
- Other Optimizer Operators
- Introduction to Optimizer Statistics Concepts
- Using Bind Variables
- SQL Plan Managements
Szükséges előképzettség
Strong knowledge of Oracle Database