We see some SQL performance (tuning) problems in the Oracle Database over and over again: certain SQL constructs that are known to be inefficient in some circumstances. If you understand your data and queries, you may be able remove these inappropriate usages and improve response times hugely. This webinar will identify some of the common issues, examine the execution plan, and explore alternatives.
This free tutorial will benefit any Oracle DBA or Developer faced with underperforming SQL.
Level: Beginner to Intermediate
Prerequisites: In addition to Oracle SQL, some experience with reading execution plans is essential. For review and/or practice reading execution plans, see How to Read an Oracle Execution Plan
Attend John’s SQL Tuning Class! Learn More.
- Lectures 8
- Quizzes 0
- Duration 60 minutes
- Skill level All levels
- Language English
- Students 87
- Assessments Yes