Step by Step approach on troubleshooting badly performing SQL queries.
Identify how internal Oracle components affects the performance of the SQL query.
Identify potential performance bottlenecks by reading the Explain plan of the queries.
Tips and Tricks to make the Oracle SQL query run faster.
Compare BAD vs GOOD Queries with Examples.
Understand how STATISTICS and CARDINALITY affects the performance of the SQL Query.
Implications of JOINS and ACCESS Methods on the performance of the Query.
Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
Advanced SQL Query Tuning Steps.