Oracle Database 19c SQL Tuning Workshop

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