Summary
Learn To
Topics
Andere trainingen

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.

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.

Topics

  • Course Introduction

  • Introduction to SQL Tuning

  • Using Application Tracing Tools

  • Optimizer Fundamentals

  • Generating and Displaying 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 Management

  • Workshops

Andere trainingen

Veri Tabanı
92 Trainingsset
Terug naar Trainingen